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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-03-12 : 08:53:36
|
| Few tables have to be transferred from one server(I) to other server(II). On daily bases, new products are inserted into the database at Server(I). In order, for the data to be updated on server(II), five tables have to be transferred from I to II. The updation has to be done, keeping in the relationships already existing on II, with other tables of II(existing database diagrams). On one of tables being transferred from I to II, the price has to be changed before going online on server II. How can we achieve this task????? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-12 : 19:06:02
|
| DTS ?Damian |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-03-12 : 20:38:56
|
| Sorry, that wasn't terribly helpful....I would set up a DTS package to do this.Firstly, use a transform data step to copy the data to the live server. Then an SQL step to update the new data.You can set up a workflow to make sure that the first step hapens before the second.BOL has lots of stuff on the specifics of DTS.Damian |
|
|
|
|
|
|
Database Maintainence Plan