Scripting Tables

[buster999]

What is the trick to scripting tables using script from scripted tables in SQL Server.

Thank you
Buster999

 

[THoey]

Talk about circular... Please explain what you are trying to ask... Terry M. Hoey

 

[buster999]

Sorry. What I mean is that I have scripted the tables in SQL Server 7 and saved the script to a file, and the question is do I now just copy that script into the SQL Plus worksheet in the database that I want to create the tables and execute, or is there more to it?

Thanks
Buster999

 

[THoey]

I am pretty sure that there are some differences between SQL Server and Oracle. An example is that Oracle uses SEQUENCES type as a sequential numeric field, usually used as a unique primary key type field. I know SQL Server has a different name for this type of field, but I can't remember what they call it.

I guess you could try and run the script and then make corrections where it errors. Terry M. Hoey

 

[Guest_imported]

Yea, SQL server calls their version of sequences as Identity
Seed; plus referential constraints are enforced differently by sql server than by oracle.
I will run my scripts first in sql server and use its dts(data transformation service) to move the tables over to oracle.
During transformation process, you will have the opportunity to generate an oracle version of the table scripts.
I have used both. If you still need help, please advise.
sokeh

 

[buster999]

Thanks alot. I will try it.