SQL Server Licensing
http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx
I need to install SQL Server 2008 R2 Standard Edition and replicate the data of 10 instances of SQL Server 2008 R2 Express. I will then have an application that will connect to the Standard Edition to generate reports.
What licenses will I need to purchase?
What is the Software Assurance for and is it required?
I need to install SQL Server 2008 R2 Standard Edition and replicate the data of 10 instances of SQL Server 2008 R2 Express. I will then have an application that will connect to the Standard Edition to generate reports.
What licenses will I need to purchase?
What is the Software Assurance for and is it required?
Aaron Tomosky
I think SQL express can only be a replication target, not a source.
ASKER
I see. But if I will be connecting to the sql server express instances as linked server, will I need to purchase a license for each sql server express (CAL)?
And what is the software assurance for?
And what is the software assurance for?
- software assurance is basically a maintenance program for corporate customers to get software free upgrades to newer versions and other benefits during a multiyear contract: http://en.wikipedia.org/wiki/Microsoft_Software_Assurance
"if I will be connecting to the sql server express instances as linked server, will I need to purchase a license for each sql server express (CAL)"
- i might be wrong but my understanding if CAL is access license to the SQL Server itself. not from the SQL Server to other database. so i think you don't need an extra license for linking to the sql express server: http://www.microsoft.com/licensing/about-licensing/client-access-license.aspx
"if I will be connecting to the sql server express instances as linked server, will I need to purchase a license for each sql server express (CAL)"
- i might be wrong but my understanding if CAL is access license to the SQL Server itself. not from the SQL Server to other database. so i think you don't need an extra license for linking to the sql express server: http://www.microsoft.com/licensing/about-licensing/client-access-license.aspx
ASKER
So in my case, I will only need 1 license for the Standard edition and 1 CAL for the application that will connect to the server. Is that correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Replication is not part of Express version.
Express come with database engine only.
Express come with database engine only.
That's niceand all that your sure about the exact product name, but can anyone agree or disagree with this statement:
SQL server express cannot be a replication host/source.
I don't think this entire setup will work.
SQL server express cannot be a replication host/source.
I don't think this entire setup will work.
To clarify, I have never done replication with express but this is what ms has to say about it
http://msdn.microsoft.com/en-us/library/ms165686.aspx
http://msdn.microsoft.com/en-us/library/ms165686.aspx