Moving data from Sql Server 2000 to Sql Server 2005

During Importing of tables from SQL 2000 DB to SQL 2005 DB, the views in the 200DB are converting to tables in 2005.

This was not happening in the DTS provided in SQL 2000.

Please help
kshakesAsked:
Who is Participating?
 
LowfatspreadConnect With a Mentor Commented:
pre-establish the tables in the sql2k5 database before running the import.
0
 
ziolkoConnect With a Mentor Commented:
generate SQL script on SQL2K run it on SQL2K5 and then import only data

ziolko.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.