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-13 : 01:55:59
|
Hello, Could someone help me to solve my problem in translating an Oracle DataBase to an SQL Server DataBase . I am using DTS wizard to translate the Oracle DataBase, but primary key constraints, foreign key constraints, and another constraints weren't translated. The second problem is that views were translated into tables instead of views although all tables ,from which views take data, are available.Thank you very much for your interactive forum, and I hope to get more knowledge to serve this forum. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
|
|
Shihab
Starting Member
7 Posts |
Posted - 2002-12-13 : 14:42:25
|
quote:
Instead of trying to transfer views, just generate scripts for those Oracle views, and run them in SQL Server.Also, you might find this useful:http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm--HTH,Vyashttp://vyaskn.tripod.com
Ok Thank you for your reply but I think that your reply is for translating views.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 |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-12-17 : 13:39:47
|
| I don't think you can get DTS to transfer constraints from Oracle to SQL Server. You might want to consider scripting those as well and applying them manually.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
|
|
Translating an Oracle DB into SQL Server DB