How to import mysql data into SQL Server 2000 ?

Hi all,
I have a *.sql backup file, is there any method to import the backup into
SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
Thanks a lot !Hi,
That is actually a dump file of MYSQL. You cant use that in SQL Server
directly. Ways to transfer data from mysql to SQL server is given below:-
1. DTS
2. Generated comma seperated text file in mysql and use BCP IN / to load it.
Better and easiest option is to use DTS to copy data between
Thanks
Hari
MCDBA
<.> wrote in message news:OWZ8OZ5QEHA.2404@.TK2MSFTNGP09.phx.gbl...
> Hi all,
> I have a *.sql backup file, is there any method to import the backup into
> SQL Server 2000 ? I cannot open it in the SQL Query Analyzer.
> Thanks a lot !
>