|
Sunday, 17 May 2009 17:33 |
|
We have a MS SQL Server database on one Server with around 350 tabels called "hotdata" here we work with the SQL server 2000
now you have to write a copy job that everyvery day it will copied the tabels of "hotdata" to an other server with SQL Server 2005
from that server 26 tabels have to copy in a differant database called "eshop"
form a other database you have to copy aournd 5 tables to the database "eshop"
finally the database "eshop" has to be copied to the host of our proviader ..everday you got me?
It should be done in a way that only the changes are copied everday ( new addreses/drtikels changes or deleted ones.
|
