dbTalk Databases Forums  

Migrate FK and PK constraints from Oracle

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Migrate FK and PK constraints from Oracle in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Raj
 
Posts: n/a

Default Migrate FK and PK constraints from Oracle - 07-20-2005 , 02:29 PM







Hi,

I used DTS to import tables and views from Oracle, but I how do I migrate
foreign key and primary key constraints? DTS does not seem to provide this
functionality.

HELP!!

Raj




Reply With Quote
  #2  
Old   
Narayana Vyas Kondreddi
 
Posts: n/a

Default Re: Migrate FK and PK constraints from Oracle - 07-20-2005 , 02:37 PM






I don't think DTS is the right tool to do this. If you are migrating a
database from Oracle to SQL Server then, you might want to use a migration
tool. For example:
http://vyaskn.tripod.com/review_swis...ne_console.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Raj" <Raj (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,

I used DTS to import tables and views from Oracle, but I how do I migrate
foreign key and primary key constraints? DTS does not seem to provide this
functionality.

HELP!!

Raj






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.