Multiple choice sql-server

Your SQL Server is running SQL 6.5 and you want to transfer the data from the SQL 6.5 server to a new SQL 7 Server. How can you do this?

  1. Using DTS Import

  2. Using bcp -out and use bcp -in to insert the data into the new SQL 7 Server

  3. Use the DTS Export

  4. Using bcp -copy, copy the data from the SQL 6.5 Server to the SQL 7 Server

  5. Both A and B
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

SQL Server 7.0 introduced DTS (Data Transformation Services), which can import data from SQL 6.5. Alternatively, bcp (bulk copy program) with -out to export from 6.5 and -in to import to 7.0 works across versions. DTS Export is for exporting data OUT, not importing. There is no 'bcp -copy' command - the correct syntax is bcp -out and bcp -in.

Keep practicing — related questions