If you have DTS you can export the data to a CSV format. If you have MyODBC
installed you could export directly to MySQL.
-Original Message-
From: Tim Winters
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 8/24/04 11:34 AM
Subject: RE: sql2000 to mysql
Hi Victor,
Just Table
You can try SQLyog's ODBC Import feature. SQLyog can
be found at http://www.webyog.com
Regards
Karam
--- Tim Winters <[EMAIL PROTECTED]> wrote:
> Hi Victor,
>
> Just Tables and Data.
>
> Ideally scripted to create the tables and insert the
> data. will sql2000
> product something similer to a
Hi Victor,
Just Tables and Data.
Ideally scripted to create the tables and insert the data. will sql2000
product something similer to a .sql file which can simple be run as a script?
Thx
At 12:45 PM 24/08/2004, Victor Pendleton wrote:
Are you wanting to move Foreign keys, Triggers, Stored proced
Victor Pendleton wrote:
Are you wanting to move Foreign keys, Triggers, Stored procedures and the
like as well or just the data?
definitely!!
so you make relations in your codes for projects...
If not use Triggers, not use Stored procedures then, You move database,
table and data with a small
Are you wanting to move Foreign keys, Triggers, Stored procedures and the
like as well or just the data?
-Original Message-
From: Tim Winters
To: [EMAIL PROTECTED]
Sent: 8/24/04 10:36 AM
Subject: sql2000 to mysql
Hello,
Can someone advise me of the best/easiest way to move an entire DB