RE: MySQL -> SapDB

[Mark Bruk]

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