thanks
Marc Boorshtein
On Sun, 2001-10-14 at 20:24, Mark Bruk wrote:
Marc,
I just did this with a small simple MySQL database.
I used phpMyAdmin to extract all tables defs and data.
I used MS-Word to:
replace all '#' with '//#'
replace all 'int' with 'fixed'
replace all 'unsigned' with ''
replace all auto_increment with ''
replace all text with varchar(2000)
replace all '0000-00-00 00:00:00' with today '2001-10-15 09:00:00'
replace all ';' with ''
then I used MS-Word to get rid of all the spaces in the create table syntax and pull the line together
replace '^p ' with ' '
then I used MS-Word to add separators for each statement
replace '^p' with '^p//^p'
this worked for me, but again I had a simple database of 100 or so tables without to many datatypes.
Hope this helps.
Regards,
Mark
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marc Boorshtein
Sent: Saturday, October 13, 2001 5:23 AM
To: [EMAIL PROTECTED]
Subject: MySQL -> SapDB
Hello,
Does anyone know of any easy way to migrate a MySQL database to SAPDB?
Thanks
Marc Boorshtein
