Hacker News Reader

Watch out! when you are using the MS SQL Server Express edition you are limited by its "subscriber only" replication mode.

MS SQL Server express cannot be used as a replication master, if you are interested in that type of architecture.

View on HN

Would it be easy to upgrade and scale the Express database later to a full-blown version of SQL Server using replication if I see that my app makes money and is worth the investment paying for a commercial SQL Server version? I think I could probably even find a hosted SQL Server, so I wouldn't have to pay full license fee. But I guess that prevents me from running on a dedicated server...Thats why I am hoping I can move it over later to some scalable solution like Mosso, and not worry about paying for the full license, only for as much as I need depending on the traffic.

If you go to a hosted solution (virtuals/rackspace/shared/whatever), the license cost of SQL is usually included.

Honestly, MSFTs licensing schemes give me a huge headache.

They aren't very straight-forward.. vs LAMP: free = free :) but... I like the tools.

Reply on news.ycombinator.com