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
