Which SQL Server edition?
Posted
by StaringSkyward
on Server Fault
See other posts from Server Fault
or by StaringSkyward
Published on 2010-05-27T22:58:20Z
Indexed on
2010/05/27
23:02 UTC
Read the original article
Hit count: 209
We need a new install of windows server and sql server to replicate a couple of databases to a geographically separate location from an existing application (over a site-to-site VPN). The source database is SQL Server 2005.
However, this is a temporary solution since the client is aiming to implement a different system entirely, so we are looking to find the minimum specification of both windows server and sql server to do this.
We are finding the SQL server features per edition and licensing a little difficult to understand, hence the question. Am I correct in thinking that we can replicate data using transactional replication from SQL Server 2005 to 2008 web edition and we can install sql server web edition on windows 2008 web edition also?
Thanks.
© Server Fault or respective owner