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 ?

Jay

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.

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