January 29, 2009 at 2:15 am
i have a server in 2000 and another in 2005.i want to add data from 2000 server to server 2005.when data is inserted in the database in 2000 server to a table in that database is automaticaly inserted in the database in 2005 server in a table.please give me the solution.
January 29, 2009 at 2:35 am
It sounds like you can use replication. Have a look at BOL about transactional replication to see it this is what you need.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply