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 |
|
TestEngineer
Starting Member
29 Posts |
 Posted - 2006-01-26 : 09:30:51
|
| I'm an engineer in a manufacturing environment. We have a centralized MS SQL Server 2000 running at each location of my company. I'm developing applications that will run on "Test stand" PCs, where product is tested. Current software works solely with csv files for data output and works independently of the network. To limit the reliance on the network, I'd like to setup small workgroups, or cells, of test stand PCs that communicate with a MS SQL Server Express 2005 that is replicated with the facility-side server databases running SQL Server 2000.Will there be any compatibility issues replicating between these two? Obviously, the SQL Server 2000 will act as the publisher. Note that our IS department will likely not go for 2005 for awhile and I have no input to get them to move to this. It will be a little bit of a dogfight to get their support on the "cell" idea I'm considering. Our faciities in Juarez have frequent internal network issues, so to maintain production, it is very important to be able to continue testing product when the main network is down.Thanks in advance for any insight. |
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2006-01-26 : 13:44:13
|
| What you are suggesting is supported, but you'll want to read the BOL topics about backwards compatibility in Replication. A list of the topics is available at http://msdn2.microsoft.com/ms143323.aspx. That should get you started.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
 |
|
|
TestEngineer
Starting Member
29 Posts |
Posted - 2006-01-26 : 17:29:45
|
Thanks mikewa,I tried to follow your link and it was apparently some dynamic content page that has been removed from the server. What should I use as a search query go get the topics? Thanks a bunch. Scratch that.. There was a period at the end of the link (for anyone else interested in following:[url]http://msdn2.microsoft.com/ms143323.aspx[/url]Tom |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2006-01-26 : 19:34:27
|
Web Forums seem to punish anyone who likes to use punctuation I guess Ill have to stop doing that Glad you found the contentRegards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
|
|
|
|
|
SQL Server 2000 with SQL Server Express 2005