 | |
DTS transfer by passing log
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS transfer by passing log -
02-27-2006
, 11:57 AM
#2
| |||
| |||
|
|
Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, |
#3
| |||
| |||
|
|
Hello mecn, In SQL Server you will never truly bypass the log. You need to set the log to SIMPLE and make sure there are no indexes or triggers on the destination. You can also do inserts in batches so the server can issue checkpoints to to the logs. You can do SQL Server to SQL Server transfer very easily Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, |
#4
| |||
| |||
|
|
Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, |
#5
| |||
| |||
|
|
hi, After I set the db to simple and using select into statement. The db taht getting records is ok, but the temp db data file grouw too big. Whatelse that i could try to import large amt of records from another table in other server. Thanks "mecn" <mecn2002 (AT) yahoo (DOT) com> wrote in message news:OvXM7c8OGHA.1124 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, |
#6
| |||
| |||
|
|
Hello mecn, SELECT INTO is only moving the issue of ize form the log to tempDB. Move the data in batches. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com hi, After I set the db to simple and using select into statement. The db taht getting records is ok, but the temp db data file grouw too big. Whatelse that i could try to import large amt of records from another table in other server. Thanks "mecn" <mecn2002 (AT) yahoo (DOT) com> wrote in message news:OvXM7c8OGHA.1124 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, |
#7
| |||
| |||
|
|
how do I move the data in batch? Thanks "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b03186e48c80a028296f5b0 (AT) msnews (DOT) microsoft.com... Hello mecn, SELECT INTO is only moving the issue of ize form the log to tempDB. Move the data in batches. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com hi, After I set the db to simple and using select into statement. The db taht getting records is ok, but the temp db data file grouw too big. Whatelse that i could try to import large amt of records from another table in other server. Thanks "mecn" <mecn2002 (AT) yahoo (DOT) com> wrote in message news:OvXM7c8OGHA.1124 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Hi, I have 200 mil records in one table need to be transferred from one server to another server fro test.What is the best way to do the transfer by passing the log? Select into? Thanks, |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.