🎴 Flashcard Mode
SQL Server Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
Both A and B
💡 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.