No. The data has to be moved from MSSQL to MySQL some way, and that will be
either an export or a copy. AFAIK, there is no way for the two RDBMS's to
communicate directly with each other ... you need some sort of intermediary.
And before any data can be moved, the table schema must be created on both
servers.
For our application, we have a written a translation program that
updates/alters our old MSSQL7 table schema to match our current MySQL
schema. It then uses an ODBC connection to port the row information from
MSSQL to MySQL.
Theer are a number of ways to do this ... a search of the list archive will
turn up many threads on this topic.
Gerald Jensen
----- Original Message -----
From: "stephen smithstone" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 4:10 AM
Subject: Populating mysql db from sql server 7
Is there ne way of populating the mysql db with the data from the sql server
db with out doing exports like a copy or something?
---------------------------------------------------------------------
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
