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


Correct Option: E

Find more quizzes: