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

Filed under:
|
|

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

Related posts about server

Related posts about sql