Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 License for Replica? Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2008 9:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 7, 2010 2:24 PM
Points: 3, Visits: 20
Hello,
Does DB replication setting requires a new license beside the existing?

Thanks,
MBarry
Post #485088
Posted Tuesday, April 15, 2008 9:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, April 15, 2008 10:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 7, 2010 2:24 PM
Points: 3, Visits: 20
Thank you Dick!
Post #485153
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse