Home > Archive > MS SQL Server DTS > July 2005 > Migrate FK and PK constraints from Oracle









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Migrate FK and PK constraints from Oracle
Raj

2005-07-20, 8:24 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



Narayana Vyas Kondreddi

2005-07-20, 8:24 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_sw...> e_console.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Raj" <Raj@discussions.microsoft.com> wrote in message
news:9C56486A-5D5A-42F9-85BE- C0EE28D9EE19@microso
ft.com...
>
> 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
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com