none
From local SQL Server Express to central SQL Server RRS feed

  • Question

  • Greetings again,

    This post is related to this one: [http://forums.microsoft.com/msdn/ShowPost.aspx?postid=2575459&siteid=1]

    I'm developing a multi-user, windows form based, case tracking application in C# using Visual Studio 2008 Express. Currently, all my data is stored in a local SQL Server Express file, but when I reach production I'll be moving to a central SQL Server of unknown version. (Probably 2005). My two questions are: (1) How do I write my code to allow for this transition? (2) How do I design my database to make this transition as easy and painless as possible? No data will follow from development to production.

    Thanks in advance for all you assistance and input.

    Kind regards,
    Stig Andersen
    Wednesday, December 19, 2007 8:35 AM

Answers

  • Hi,

     

    When utilizing ADO.NET to access database on Microsoft SQL Server, the steps are generally similar, except that the connection string may vary as the SQL Server edition. Thus, for the purpose of easy transition, I suggest you save the connection string in the app.config file. When transiting from one edition to another, you needn’t modify your code; just modify the connection string in the app.config file.

     

    Secondly, different editions possess different features. Thus, I recommend you not to utilize features specific to some editions, try to utilize common features as much as possible. This will be helpful for transition.

     

    For features of different editions of SQL Server 2005, please refer to:

    http://technet.microsoft.com/en-us/library/ms143761.aspx

     

    Hope this helps!

     

    Friday, December 21, 2007 5:32 AM

All replies

  • Hi,

     

    When utilizing ADO.NET to access database on Microsoft SQL Server, the steps are generally similar, except that the connection string may vary as the SQL Server edition. Thus, for the purpose of easy transition, I suggest you save the connection string in the app.config file. When transiting from one edition to another, you needn’t modify your code; just modify the connection string in the app.config file.

     

    Secondly, different editions possess different features. Thus, I recommend you not to utilize features specific to some editions, try to utilize common features as much as possible. This will be helpful for transition.

     

    For features of different editions of SQL Server 2005, please refer to:

    http://technet.microsoft.com/en-us/library/ms143761.aspx

     

    Hope this helps!

     

    Friday, December 21, 2007 5:32 AM
  • Thanks! That's very helpfull.

    Kind regards,
    Stig Andersen
    Friday, December 21, 2007 7:56 AM