On Oct 25, 6:47 pm, "kristincollin...@gmail.com"
<kristincollin...@gmail.com> wrote:
> I have a SQL Enterprise database that I need to import into a MySQL
> database. I generated a .sql file using the SQL Enterprise generate
> script tool, and when I try to import the file. I get the following
> error.
>
> ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
> check the manual that corresponds to your MySQL server version for the
> right syntax to use near 'IF EXISTS (SELECT name FROM
> master.dbo.sysdatabases WHERE name = N'lobster')
> DR' at line 1
> "
>
> Any help is appreciated.
>
> Thanks!

Hi,
In MySQL we dont have the master system database, which is present
in SQL Server. So its quite obvious that any reference to these
databases in the script would cause the script to fail.
I still doubt as to why the script are failing. Are you simply
transfering data or are you also creating the tables from the script
onn your target database. In case of scripts that do just DML, there
shoudl not be any problems.
Hope this helps.

Regards
Jackal