Now pb dw_1 20 is sql2000 database in the table, I am going to put all these tables into the oracle database, how to implement the table structure in the pb, please copy (no data pipeline)? It is better for specific program statements or similar example,

CodePudding user response:

It is better to pipe! Or use the MSSQL tool
Because of different database, grammar is not exactly the same! Without treatment, easy to a problem!
Or use a modeling tool to generate oarcle table structure script! Pb then execute the script!

CodePudding user response:

Seven 20 tables, I've done in the table, more than 80 fields, make for a week, get the hell out of me, it seems that you are a difficult task!

CodePudding user response:

You can first the data retrieved data in SQL server window, in the data source field type to use the convert function is converted to the corresponding oracle data types, build an oracle corresponding data window, use the data in the SQL data window rowscopy copy () function to oracle data window, then oracle data window to save the data to the oracle database,

CodePudding user response:

Ramboo2002, could you give me leave a your contact information? Such as QQ or MSN, I would be grateful,

CodePudding user response:

[email protected]

CodePudding user response:

A little difficulty oh