SQL Server Quiz

Casual Mode - Take your time!

1 / 20
✓
Correct
0
✗
Incorrect
0
★
Score
0%
Multiple Choice

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
Change Mode