Foreign keys and DTS

• aapen

  Grasshopper

  Points: 11

  More actions

  February 6, 2003 at 5:53 am

  #80204

  I was hoping somebody could help me out, I am converting a production system from Oracle to SQL Server using DTS and (due to the large amounts of data being converted and the fact it has to run every night to allow testing on real data) I need to drop and recreate each of the tables I am populating to clear them out prior to repopulating them. The problem I am having is that our developers have creted loads of foreing keys and these are stopping me from dropping the tables. Does anybody know a quick way of creating a script to create all the foreign keys? Or do I just have to go through the database one table at a time copying the create scripts from Query Analyser?

• BobSmith

  Grasshopper

  Points: 11

  More actions

  February 6, 2003 at 6:04 am

  #448201

  Oops - posted this on my bosses login!! Please don't e-mail him, he'll shout at me and make me do unpaid overtime!!

  Cheers

  Bob