transfer large amt of records

microsoft.public.sqlserver.server

29 Nov 2007 4:22 PM

mecn

Hi, What is the best way to transfer large records 50 millions / week from
one sql server to another.
I need to autimate the weekly process. I can do it bypassing transaction log
file...

THnaks,

29 Nov 2007 9:22 PM

Andy

Both backing up the database, or using import/export packages in SQL
Server Management studio will copy records from one instance to
another. But, neither approach deletes the copied records from the
source database, so these methods don't really "move" the records.

You will probably have to write a SQL Script (or VB program) and use
SQL statements to copy the records and delete them from the source.
You can prefix the tables with the database names followed by a period
to differentiate data between the two SQL Server instances.