Question for anyone that handles SQL Replication: What effect would setting up transactional replication from a large Windows 2000 database (17 Gb) with moderate usage (18-20 max simultaneous connections) to a Windows 2005 server have on the performance of the Windows 2000 machine?
The reason behind the question - We use Microsoft Dynamics GP with 4 different SQL databases housed on a SQL 2000 server. We are building a web application to query those databases (read only) as well as store some data that they are not set up to manage. It uses a SQL 2005 server. Right now the app is running slow because the queries are running through the SQL 2005 as a linked server. My thought in speeding things up is to set up replicated copies of the 4 databases on the SQL 2005 server. This would be a transactional replication so we have instant access to any changes made in the main system. Additionally, the remote possibility of an injection attack running back to the live Dynamics databases would be removed. Our worry is that setting up the replication would place a noticeable strain on the main server, something we cannot afford to have. Any thoughts, ideas or suggestions? Thanks! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:288371 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
