Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004

    Unanswered: Any tips on parallel development mysql & mssql

    We are not using any SP's . Our platform is C# on .NET and we need to support both databases.

    Any tips on developing for both data bases at the same time ?


  2. #2
    Join Date
    Sep 2009
    If possible, try to use standard SQL as much as possible. In other words, don't use SQL dialect specific to a SQL server.

    Another way is to have a SQL statements defined similar to the way a translation would. For example, you have a list of SQL statements for MSSQL in one file and for MySQL in different file. Depending on configuration of which database is used, one of the 2 files are loaded.

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    or consider abstracting the database layer out into database specific classes

    sticking to standard SQL is a smart call, but sometimes you just get the itch toi use propriatorial extensions to SQL
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts