Web Wiz Forums - MySQL and SQL Server

Print Page | Close Window

MySQL and SQL Server

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31482
Printed Date: 29 March 2026 at 4:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MySQL and SQL Server

Posted By: wonderbison
Subject: MySQL and SQL Server
Date Posted: 29 May 2017 at 5:54pm

Hi

Can I assume that the schema details is the same between MySQL and SQL Server. In otherwords I can create a MySQL database and just simply migrate the data across?

Do I need to be aware of any IDENTITY values creation or anything like that?

Thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 30 May 2017 at 12:14pm

MySQL and SQL Server are very different so the schema is very different, and identity values are used as foreign and primary keys so need to be correct.

Support for mySQL was only introduced as at the time SQL Server was sold as a expensive premium service by web hosts. Now that SQL Server is included with even the cheapest Windows Hosting Packages you should use SQL Server and not mySQL for Web Wiz Forums.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting