Converting from Mysql to Mssql

[Antithott]

Hi, i'm hoping someone here can help out with this question, as its going to be alittle work if its not possible.

I have been working on a project for the past month which use MySql as DB, but now i need it changed to MsSql.

Does anyone know of a good way or a program to check if my CMD strings from MySql is valid in MsSql format?

There is a slight diffrence as i have seen.

I tried searching but i didnt seem to find anything giving me a good answer, hopefully i didnt miss any posts.

 

[ca8msm]

[google]mysql to mssql[/google]

The first result may be of some interest. Also, you could just setup a temporary database and try it out.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[SQLSister]

If you look at the last book listed in this FAQ it will show the differnces in SQL code between the two database. This will be very useful to you.

And personally I would not use cmd strings to send code, but would use stored procs instead, they are generally faster and more secure.

"NOTHING is more important in a database than integrity." ESquared