one, 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
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 int
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 archi
