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 |
|
kirbyf
Starting Member
3 Posts |
 Posted - 2008-10-02 : 17:04:24
|
| Hi,I'm trying to setup a two-way transactional replication between 2005 x64 and SQL 7.0I keep finding tons of articles on setting up replication, but they never seem to cover this particular situation. I'm happy to read more articles, I just need to be pointed in the right direction.Our current ERP system is Great Plains dynamics 5.5, which is limited to SQL server 7.0, partly because they use the old SUID columns in the system tables for their login procedure.I just built a ferrari of a SQL server box and installing Win2K and SQL server 7.0 wouldn't fully utilize this new server, so I'd like to have the Great Plains databases identical across both servers (the new 2005x64, and the old 7.0 server). All of our custom tool which are version independant can run on the new server, and all the old GP processing can run on the old server.Our database size is about 70GB and we might have a million transactions per day during busy season.Thanks!Kirby |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
|
|
|
|
|
2005 to 7.0 Transactional replication