Importing Ms SQL DB in MaxDB

[former_member135688]

Hi Guys,

I have previously a DB in MSSQL and Now I would like to import this in Maxdb is it possible that I can import Ms SQL base Tables in MaxDB? if yes Could you please tell me how?

Regards

Yasir Noman

[TTK · Accepted solution]

Hello Yasir

dtswiz.exe is a transport tool of MS SQL. You can try to transfer data to a MaxDB with the ODBC driver.

HTH Thomas

[former_member135688 · Accepted solution]

Hi Thomas,

Thanks a lot for the reply, well I have never used this dtswiz.exe where can I find it second do you know if we have How to Guide for this...

Thanks

Regards

Yasir

[TTK · Accepted solution]

IIRC, it belongs to the Enterprise Tools of MSSQL. I don't know, whether you can get it somewhere as download.

Handling is like a wizard, so a guide is not necassary.

Sorry for the delay

Thomas

[former_member229109]

Dear Mr. Noman,

If you are running SAP system with MSSQL DB, it will run on MaxDB too.

You can migrate your system by performing a heterogeneous system copy

(that is, exporting the database with the R3Load program, re-installing the SAP

system and then re-importing the database). All conversions and adjustments of

data are covered by the R3Load program. Of course, any migration to another

database will lead to some additional customizing on secondary keys, etc.

-> You wrote:

"I would like to import this in Maxdb is it possible that I can import Ms SQL

base Tables in MaxDB?"

Writing tables to a file and importing with the loader might be a solution

for you. On the other hand, you could use the tools JDBC or ODBC.

Please see the information about Loader at MAXDB library:

http://dev.mysql.com/doc/maxdb/en/7e/c3fb0e72fcf84580f7ee9fcec672b7/frameset.htm

And please review the helpful info 'MaxDB FAQ' at:

http://dev.mysql.com/doc/maxdb/maxdb_faq.html

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Sir,

I want to perform OS/DB migration from MS-SQL (windows ) to sap MaxDB windows.

please forward me If you have any preparation or estimation reference documents.

may mail id : deerusap@gmail.com

Regards

Diru

[thorsten_zielke]

Hello Diru,

this thread is from July 2006, please create a new post for any questions not answered here and state if the migration is for a SAP system (then you could use the R3load tool) or just the database in a non SAP environment.

Thorsten