MySQL and SQL Server

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
wonderbison Members Profile Find Members Posts Groupie Joined: 18 May 2007 Location: United Kingdom Status: Offline Points: 51	Post Options Post Reply Quote wonderbison Report Post Thanks(0) Quote Reply Topic: MySQL and SQL Server 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.