Convert MySQL script to SQL Server script

Hi there,
I have a few MySQL scripts that I need to run in SQL Server. However the
syntax is just slightly different and I was wondering if there is a tool out
there that can quickly convert these scripts so that they will work with SQL
Server?
Anyone have any ideas (other than manually converting them)?
Thanks,
Wes
Hi,
There is one possible way how to do it, however, it's not as direct as
you may wish.
Let me outline what to do. You will have to run the scripts "above"
MySQL database and reverse engineer them in CASE Studio 2 (a database
modeling tool) that allows you to do the conversion to MSSQL in just a
few clicks. Then you can generate a script compatible with MSSQL.
You can try to do it in the CASE Studio 2 demo version, which is for
free >
http://www.casestudio.com/enu/download.aspx.
To learn more what this product is about, please feel free to visit:
http://www.casestudio.com/enu/default.aspx.
Finally, I think this could help you until somebody else gives you
better advice.
Good luck.
Vladka
Wes <Wes@.discussions.microsoft.com> wrote in message news:<2C048E65-7A06-49C1-BE96-8A5F3716E4EF@.microsoft.com>...
> Hi there,
> I have a few MySQL scripts that I need to run in SQL Server. However the
> syntax is just slightly different and I was wondering if there is a tool out
> there that can quickly convert these scripts so that they will work with SQL
> Server?
> Anyone have any ideas (other than manually converting them)?
> Thanks,
> Wes
|||Hi Vladka,
I downloaded, installed and tried CASE Studio 2, but to no advantage. It
will not allow me to import or open an existing script. I tried everything I
could think of, but could not get it to allow me to use my existing script.
Thanks for trying though!
Wes
"Vaclav Frolik" wrote:

> Hi,
> There is one possible way how to do it, however, it's not as direct as
> you may wish.
> Let me outline what to do. You will have to run the scripts "above"
> MySQL database and reverse engineer them in CASE Studio 2 (a database
> modeling tool) that allows you to do the conversion to MSSQL in just a
> few clicks. Then you can generate a script compatible with MSSQL.
> You can try to do it in the CASE Studio 2 demo version, which is for
> free >
> http://www.casestudio.com/enu/download.aspx.
> To learn more what this product is about, please feel free to visit:
> http://www.casestudio.com/enu/default.aspx.
> Finally, I think this could help you until somebody else gives you
> better advice.
> Good luck.
> Vladka
>
> Wes <Wes@.discussions.microsoft.com> wrote in message news:<2C048E65-7A06-49C1-BE96-8A5F3716E4EF@.microsoft.com>...
>
|||Hi Wes,
I'm sorry for the inaccurate formulation. You're right, CASE Studio 2
(CS2) can load only the physical database, not SQL scripts. (As I
wrote - it wasn't a direct way... ) However, I'd like to specify my
previous message.
1.Please, try to generate the script physically in MySQL database.
2.Then reverse engineer this database in CS2 again. For the details
concerning reverse engineering, please have a look at the Help file
Contents folder > Reverse engineering.
3.Furthermore, you will have to do the database conversion. Please, see
the Help file of CS2 > Contents
folder > Model conversion for the details.
4.Finally, you'll be allowed to generate the scripts of the converted
database automatically. Please, see the Help file again > Contents
folder > Databases > MS SQL > Generating SQL scripts.
Well, this will certainly help you. Good luck!
Here are the needed links once again:
http://www.casestudio.com/enu/default.aspx
http://www.casestudio.com/enu/download.aspx
Let me also add a link where you will find some useful movies that could
help you: http://www.casestudio.com/enu/dmovies.aspx
I look forward to your reply.
Vladka
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!