Red Gate forums :: View topic - Table Creation Order IRT Foreign Keys?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Table Creation Order IRT Foreign Keys?

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DavidP



Joined: 04 May 2006
Posts: 2

PostPosted: Thu May 04, 2006 12:08 am    Post subject: Table Creation Order IRT Foreign Keys? Reply with quote

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!
Back to top
View user's profile Send private message
James Moore



Joined: 21 Nov 2005
Posts: 245

PostPosted: Thu May 04, 2006 9:05 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
DavidP



Joined: 04 May 2006
Posts: 2

PostPosted: Thu May 04, 2006 4:12 pm    Post subject: Reply with quote

That does look like a good fit. Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group