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 Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
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
