Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Convert MySQL script to SQL Server [closed]

Tags:

sql

mysql

sql-server-2008

code-migration

I have a large MySQL set of commands in a file (script) and I need to execute it on a Microsoft SQL Server 2008. I know there are few differences in both languages, despite the fact the base SQL is the same.

Is there any way how to convert a MySQL script to one that is executable on SQL Server? Or is there any migration app that can easily take the whole MySQL server and replicate everything on SQL Server 2008?

Thanks for any advice.

like image 573
NumberFour Avatar asked Nov 20 '09 14:11

NumberFour

People also ask

Can you convert MySQL to SQL Server?

After you have connected to MySQL, connected to SQL Server or SQL Azure, and set project and data mapping options, you can convert MySQL database objects to SQL Server or Azure SQL Database objects.

How do I run a MySQL script in SQL Server?

To run SQL script in MySQL, use the MySQL workbench. First, you need to open MySQL workbench. Now, File -> Open SQL Script to open the SQL script. Note − Press OK button twice to connect with MySQL.

1 Answers

I tried Full Convert Enterprise with quite big success. Fast, easy and it did my job. Give it a try it may help you

like image 168
ppolyzos Avatar answered Sep 21 '22 11:09

ppolyzos
Sign in to Comment

Related questions

Fresh mysql-server installation does not ask for password
Execute MySQL Stored Procedure using Command Line
How to run raw SQL Query with Zend Framework 2
Mysql COUNT(*) on multiple tables
Show records from now() till next 7 days in mysql
Mysql in PHP - how to update only one row in table but with greatest id number
SELECT UNION as DISTINCT
Can't load mysql.web assembly
WordPress prepared statement with IN() condition
error: command 'x86_64-linux-gnu-gcc' when installing mysqlclient
Update a boolean to its opposite in SQL without using a SELECT
Access MySQL field's Comments with PHP
Deleting ALL products on Magento
MySql Last Insert ID, Connector .net
Class does not have a table or tablename specified and does not inherit from an existing table-mapped class
Storing "CASE WHEN" condition in Doctrine2 entity
Access to MySQL with R using a pre 4.1.1 authentication protocol
How to avoid jobs DB table locks issue when using Laravel queues?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!