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 |
|
turtle1353
Starting Member
9 Posts |
 Posted - 2005-10-14 : 13:08:31
|
| Help needed please from the SQL team, I need to import data from one table on to another on a regular basis (twice a day). Sorta like...From:Server1Db1Table1To:Server2Db1Table1I used DTS to get the data initially from Server1 but how I can do it on a automated basis?Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-14 : 13:41:03
|
| Schedule the DTS job?Or schedule some SQL that does:INSERT INTO Server2.Db1.Table1SELECT *FROM Server1.Db1.Table1(with a TRUNCATE TABLE Server2.Db1.Table1 or a DELETE Server2.Db1.Table1 first if you need to pre-clear the data)Kristen |
 |
|
|
|
|
|
Importing data on regular schedule