SQL Server 2005 License for Replica?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » SQL Server 2005 License for Replica?

SQL Server 2005 License for Replica?

Rate Topic

Display Mode

Topic Options

Author

Message

Mohamed Barry

Posted Tuesday, April 15, 2008 9:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 07, 2010 2:24 PM
Points: 3, Visits: 20

Hello,
Does DB replication setting requires a new license beside the existing?

Thanks,
MBarry

Post #485088

dbaker-620086

Posted Tuesday, April 15, 2008 9:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 28, 2009 2:09 AM
Points: 112, Visits: 196

in SQL200x products replication is FREE (unlike competing vendors)

exceptions
1. if doing Oracle-SQL replication you would need SQL2005 Enterprise Edition
2. SQL/Express and SQLCE can be subscribers (not publisher or distribution engines)

BTW, you can
A. have immediate/queued updating for transactional
B. have merge repl and peer-peer if such topologies are required
C. replicate from SQL to non-SQL via OLEDB/other data providers

if you have a mobile scenario you should also look at ADO Sync (new functionality in Beta)

HTH
Dick

Post #485129

Mohamed Barry

Posted Tuesday, April 15, 2008 10:26 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 07, 2010 2:24 PM
Points: 3, Visits: 20

Thank you Dick!

Post #485153

« Prev Topic | Next Topic »

Permissions