Automatically read primary key and foreign constraints

• thelonestar

  SSC Rookie

  Points: 26

  More actions

  July 7, 2005 at 8:44 am

  #69300

  Hi!

  I wanted to migrate from oracle to mssql server and trying to do this with dts. I tried it, but no primary key or foreign key were read out. Is it possible to get this information automatically by dts??

  Are there any other possibilities to achieve this (except using commercial third party tools) ?

   

  Thanks for any help.

  Regards,

  thelonestar

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 8, 2005 at 10:36 am

  #572503

  Suggest that you use BOL and look at

  sp_helpconstraint 'tablename', 'nomsg'

  to give you an idea of what is readily available.

   

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]