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 |
|
abcxyz
Starting Member
1 Post |
 Posted - 2008-04-15 : 13:34:39
|
| Hello,I have SQL Server 2000 and 2005 running on the same server. My current system is in SQL Server 2000 and the new system is in SQL Server 2005. My users will be using SQL Server 2000 for the most part, But for the part the processes that have been migrated to 2005, they will be using SQL Server 2005 as well. The database schema is different on both servers eventhough the data will be similar in most respects. Is there is a way through which any data that is inserted/updated in SQL Server 2000 via content Management System/ manually/ via a batch job, the data is automatically populated in SQL Server 2005 tables or vice versa?Please advice at the earliest.Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-15 : 22:46:07
|
| Not easy with replication due to schema difference, and sql2k5 db may use data type that doesn't support in sql2k. Will trigger work? |
 |
|
|
|
|
|
Data Sync between SQL Server 2000 and SQL Serv