SQL Server Data Conversion considerations

SQL Server should convert data into scripts and then convert data. Direct data import will invalidate the primary and Foreign keys and constraints.

Use the built-in import and export work SQL2000. Fortunately, sql2005 always has some inexplicable errors. It is better to write a script:

----------------------
Declare @ index int set @ Index = 0
Declare @ table varchar (100)
Declare Cu cursor
Select name from SYS. objects where type = 'U' order by name
Open Cu
Fetch next from Cu into @ table
While @ fetch_status = 0
Begin
Exec ('truncate table '+ @ table +'
Insert into '+ @ table +'
Select * From vsat_jj_data.dbo. '+ @ table +'
')
Set @ Index = @ index + 1
Print @ table
Print @ Index
Fetch next from Cu into @ table
End
Close Cu
Deallocate Cu
--------