topic Load table structure definition from Sql server and mirroring in Application Development and Automation Discussions

Load table structure definition from Sql server and mirroring

Former Member — Thu, 27 Oct 2005 09:01:27 GMT

Hi, we have to replicate some tables from sql server

into SAP dictionary.

Is there a tool/transaction for import the table structure

from a DBRMS like sql/oracle ?

Adn is there some third part solution for replicate data

from/to sql server and Sap ?

Thanks in advance.

Riccardo Galli.

Former Member — Thu, 27 Oct 2005 09:10:46 GMT

Hi,

Dont know if there are any tools for this but onething is sure you will need to create the table thru SE11.

I had done something similar, created a BDC to create table and it works.

Provide the BDC with list of fields, datatype, len, key fields and the BDC will create the table.

You will need to activate the table once its created, for some reason sap put the table in "partial active" status after creation .

Good luck.

Ravi

Former Member — Thu, 27 Oct 2005 13:02:28 GMT

Thanks for the answer.

andreas_mann3 — Thu, 27 Oct 2005 13:37:25 GMT

Hi Riccardo,

have a look to that thread:

Andreas

Former Member — Thu, 27 Oct 2005 16:35:05 GMT

Thanks in advance,is there also the possibility to

read from Sql server/Oracle external database (i think from DB2).