Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shihab
Starting Member
7 Posts |
 Posted - 2002-12-14 : 22:13:39
|
| What is about translating tables with their constraints such as primary key, foreign key, and other constraints. When I translate these tables by using DTS Wizard, their Key Constraints are not translated Thank you very much |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-15 : 00:32:18
|
| DTS moves data, and only copies enough of the table structure to ensure that the data can import correctly.I'm pretty sure Oracle has a feature that will generate the SQL for a table, including constraints and keys. Generate this script from Oracle and execute it in SQL Server. Other than data type translations (varchar2 to varchar, for example, possibly other Oracle-specific types need tweaking) it should work perfectly. Once the tables are created you can DTS the data directly into them. |
 |
|
|
Shihab
Starting Member
7 Posts |
Posted - 2002-12-15 : 05:44:33
|
quote:
DTS moves data, and only copies enough of the table structure to ensure that the data can import correctly.I'm pretty sure Oracle has a feature that will generate the SQL for a table, including constraints and keys. Generate this script from Oracle and execute it in SQL Server. Other than data type translations (varchar2 to varchar, for example, possibly other Oracle-specific types need tweaking) it should work perfectly. Once the tables are created you can DTS the data directly into them.
Thank you (Mr. robvolk ) for your reply Could you give me this feature which enable me to generate a SQL script and execute it in SQL ServerThank you very much Shihab |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-15 : 08:36:06
|
| I don't know Oracle well enough. Perhaps the EXPLAIN command will do it, but you'll probably have to ask in an Oracle forum. |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-15 : 10:09:37
|
| There's a good white paper here (from the SQL2000 Resource Kit)[url]http://www.microsoft.com/sql/techinfo/deployment/2000/MigrateOracle.asp[/url]HTHJasper Smith |
|
|
|
|
|
|
|
|
Translating an Oracle DB to SQL Server DB