SQL LanguageSQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Language section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
On server x I have a large SQL server 2000 database (Call it A) with a very large amount of daily transactions. The database X only holds 6 months worth of data the rest is archived to tape. We keep only six months of data so the performance of the application is not affected.
On Server y I have a copy of database A (Call it database B) in SQL SERVER 2008. I would like to add new records and modified records that occur on database A on serer x to accumulate in database B on server Y so we can have 2 years of data for reporting purposes only. Having close to real time changes and inserts of new records would be preferred.
Coping data from db to another on diff server
Linear Mode
