MySQL / MS SQL - jsp development  
Author Message
R-dog





PostPosted: 2005-3-26 8:56:00 Top

java-programmer, MySQL / MS SQL - jsp development I am working on a jsp project that uses a MySQL database,
i wonder if the backup (.sql) file of MySQL can be executed on a MS SQL
server.

sorry for sort of off-topic of the forum.

Thanks so much
ran


 
Lisa





PostPosted: 2005-3-26 10:04:00 Top

java-programmer >> MySQL / MS SQL - jsp development
"R-dog" <email***@***.com> wrote in message
news:d22bv0$brk$email***@***.com...
> I am working on a jsp project that uses a MySQL database,
> i wonder if the backup (.sql) file of MySQL can be executed on a MS SQL
> server.
>
> sorry for sort of off-topic of the forum.
>
> Thanks so much
> ran

Of course it depends on whether you use some sql commands
that don't exist in standard sql. Otherwise it should be fine.


 
Chris Smith





PostPosted: 2005-3-26 13:06:00 Top

java-programmer >> MySQL / MS SQL - jsp development Lisa <email***@***.com> wrote:
> Of course it depends on whether you use some sql commands
> that don't exist in standard sql. Otherwise it should be fine.

If it's a backup file (as in the OP), then it probably contains commands
to create data... and it's almost certain to contain non-standard SQL.
For example, it's impossible to build a database worth the term in MySQL
without appending "InnoDB" to the end of every CREATE TABLE statement,
and that's certainly not standard SQL.

--
www.designacourse.com
The Easiest Way To Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation
 
 
Lee Fesperman





PostPosted: 2005-3-26 14:58:00 Top

java-programmer >> MySQL / MS SQL - jsp development Lisa wrote:
>
> "R-dog" <email***@***.com> wrote in message
> news:d22bv0$brk$email***@***.com..
> > I am working on a jsp project that uses a MySQL database,
> > i wonder if the backup (.sql) file of MySQL can be executed on a MS SQL
> > server.
> >
> > sorry for sort of off-topic of the forum.
> >
> > Thanks so much
> > ran
>
> Of course it depends on whether you use some sql commands
> that don't exist in standard sql. Otherwise it should be fine.

Even standard sql won't always help you. MySQL is very weak in supporting standards. MS
SQL is much better but still has significant differences.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)