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

Best way foward Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 9:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:52 AM
Points: 210, Visits: 378
I have a windows service written in .NET 4 C# that at the moment connects to a remote DB server which I am using for free (size 1.5 GB)

I am going to need to move it soon and and I am debating whether to get a rackspace/cloud server and install a free version of SQL Server
or try and put the DB into the actual .NET Service app code e.g SQL CE.

I don't know what the size limit is for CE or the limitations as I do use SQL Agent to run timed jobs although I can replace these with timers.

What do you think I should do?
Post #1408519
Posted Thursday, January 17, 2013 12:01 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:24 PM
Points: 12,906, Visits: 31,984
SQL2012/2008R2/2008 Express is free, allows a database of 10 gig, and is much much easier to use than CE;
CE is a very trimmed down database version that is aimed towards the old Windows handhelds.
It will not mix well with anything you've already written, the learning curve on the handicaps/limitations is very big,and it's designed more as an alternate to Access or a local file access type of database.

I would recommend that before anything else.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1408557
Posted Friday, January 18, 2013 3:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 9:52 AM
Points: 210, Visits: 378
Ok thanks

I haven't really done anything in CE apart from follow some basic tutorials about checking for and creating a database, and then running some sql. It seemed like it would be a right pain to swap from a big DB full of stored procedures and functions to CE.

I thought the limit of the free SQL DB was 2gb for some reason not 10GB but that is even better. Looks like a Rackspace cloud server is the way to go unless anyone has any better recommendations.

I am in the UK and have a LINUX box in Texas with them and the good thing is the exchange rate as even though the dollar $ amount is going up each month the actual £ price has gone down.

If anyone knows of any better cloud VM hosting companies that would be perfect for running just an SQL DB and an SQL windows service then please let me know.

Thanks
Post #1408796
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse