Post reply

Best way foward

  • January 17, 2013 at 9:58 am

    #287812

    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?

  • January 17, 2013 at 12:01 pm

    #1578430

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 18, 2013 at 3:44 am

    #1578617

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply