Or you could use MS Access ... set up an ODBC connection to each server,
then 'Get external data' and 'link tables'.
You still need to translate your MySQL create/alter scripts to MSSQL7
Transact-SQL, and create the databases amd tables on the MySQL server. Once
that is done, link the tables with access, copy from MySQL to the clipboard,
then Paste-Append to the MSSQL7 database.
Gerald Jensen
----- Original Message -----
From: "Alex Nguyen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 6:38 PM
Subject: Re: Exporting to SQL Server
Well, there's the hard way, but it insures your data will be intact and
you'll have proper documentation of your old and new environments....
1) take your create table scripts and translate them in the Transact-SQL
dialect
2)Create tables in MS SQL Server with scripts
3)Export data from MySQL into CSV's or other form
4)Use bcp or DTS to load data into SQL Server
> Does anyone know how to export from a MySQL database to SQL Server? Thanks
> in advance.
>
> Brian
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
