Table Creation Order IRT Foreign Keys?

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Table Creation Order IRT Foreign Keys?

Postby DavidP » Thu May 04, 2006 12:08 am

First off, wow! I put a set of tables that I've known for a long time into the tool and seeing the balloon graph made me see them in a whole new light. Great job.

Can the tool tell me in what order my tables need to be created in order to accomdate foreign keys? I'm generating schema creation scripts and don't feel like manually rearranging the tables so that the script runs correctly.

Thanks!
DavidP
 
Posts: 2
Joined: Thu May 04, 2006 12:04 am

Postby James Moore » Thu May 04, 2006 9:05 am

I dont think that SQL Dependency Tracker can do this easily (I'm sure Dan will confirm this or tell you how to achieve what you want later on) however you might want to look at our SQL Compare Tool (http://www.red-gate.com/products/sql_compare/index.htm). If you compare your current database against an empty database it will create a schema creation script for you with all of the dependencies in the right order.

SQL Data Compare can be used to migrate the data.

Hope this helps and glad you like the tool!

- James
--
James Moore
Red Gate Software
James Moore
 
Posts: 242
Joined: Mon Nov 21, 2005 9:35 am

Postby DavidP » Thu May 04, 2006 4:12 pm

That does look like a good fit. Thanks!
DavidP
 
Posts: 2
Joined: Thu May 04, 2006 12:04 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests