I have been asked to move one of our companies datawarehouses from SQL Server 2000 to 2005. I have made a backup of the 2000 datawarehouse and the .bak file is almost 14Gig. I have also saved the create scripts. What would be the best way to do this migration?
Do I create the tables on 2005 using the scripts i generated and then import the backed up data? if so what is the best way to compress this file since moving 13gig from 1 side of the world to the other on our network will be VERY, VERY slow. Or is there
another better more efficient way?
View Complete Post