Running Script in Sql Server

[sobi1995]

when I want to execute a script in SQL server I get some errors! are they different? MySQL and SQL server I mean

[dr5hn]

@sobi1995 I think so !! But what are the errors?

[sobi1995]

they are syntax errors!
what can I do?

[dr5hn]

@sobi1995 Can you post them here? So that I can check and if possible we can fix it.

[bregoh]

@sobi1995 the sql file is mostly compatible with mysql server, hence the syntax error.

My suggestion is you use the csv file or json file using programming code to update the database. If you need assistance let me know.

[dr5hn]

@sobi1995 //cc @bregoh I want to make this Database compatible with SQL Server as well.

[sobi1995]

@sobi1995 Can you post them here? So that I can check and if possible we can fix it.

[sobi1995]

@sobi1995 the sql file is mostly compatible with mysql server, hence the syntax error.

My suggestion is you use the csv file or json file using programming code to update the database. If you need assistance let me know.

thanks
I thought the same

[dr5hn]

@sobi1995 Thanks for the screenshot. If you can wait, I will fix these issues by this weekend and make it SQL Server compatible.

[sobi1995]

@sobi1995 Thanks for the screenshot. If you can wait, I will fix these issues by this weekend and make it SQL Server compatible.
thanks
I wanted to fix that and send a pull request but I wait for you

[dr5hn]

@sobi1995

In the meantime, If you want to fix it, please go ahead.

You can use this site for syntax comparison
http://www.sqlines.com/sql-server-to-mysql

If you've got a windows machine, You can also download the tool for conversion, you need to just put our SQL script and click on convert.
http://www.sqlines.com/download