Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server 2008 / SQL Express

Author  Topic 

adamsmithliverpool
Starting Member

1 Post

Posted - 2011-11-15 : 12:46:43
Hello,

I have been reading around on this forum but haven't found anyone who has asked this before (although am sure it must have come up).

I apologise in advance as am a SQL guru by any stretch of the imagination.

My question is this.

I have a SQL Server 2008 DB which will be hosted in the cloud and a select number of people will be able access this server through an ASP application. As I want members of the public to also add to this DB but did not want to pay the license CPU license fee for SQL i thought what i could do is use SQL express as a staging table so people could add information to the SQL express DB and this would automatically be pushed into the corresponding table in the SQL 2008 DB.

I have a few questions around this really.

1) can you do this easily with DB mirroring?
2) is this legal, I feel like I might just be trying to avoid paying for the CPU license for SQL

thanks in advance

Adam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-15 : 13:24:48
1. No, mirroring is not for this type of thing. Replication would be the technology to use.
2. Doesn't sound legal to me.

Can't you use CALs though? Restrict how many users you can have.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -