Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-16 : 09:33:00
|
| Michael writes "I'm using SQL Server 2000 to store data on a server and I'm looking for the most efficient way to migrate the SQL Server tables to another SQL Server installation on another server. I could use the DTS tools to create tables and copy the records, but with millions of rows to copy, that will take a long time. I could also download the data through DTS to a flat file, put it on a CD and then upload it into the other server using the Bulk Insert capabilities, but this seems like a lot of steps just to get the data transferred.Does anyone know how to quickly move SQL Server tables directly from one SQL Server database to another when millions of rows are involved??Thanks for any insight,Michael " |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-07-16 : 09:55:50
|
| Unless you have a very slow network connection between the two servers, then DTS should do just fine. I've transferred 100,000s of rows without major difficulty, even over internet connections (400,000 rows from an Oracle DB in GA, routed through my SQL Server in NY, to another SQL Server in LA, in about 20 minutes)You could also perform the migration using linked servers. That would allow you to do simple INSERT INTO... statements. See more about linked servers in Books Online, if you think you might want to try it. |
 |
|
|
|
|
|
|
|
Moving Large Tables in SQL Server