Hi,I'm currently working with a database made up from 200+ tables. I require a list of all of these tables, in the order that they must be created (table A cannot be created before table B if table A depends on table B). I've tried Red Gate's SQL Dependency Tracker but it hasn't helped. Hope you can provide some assistance.Thanks,Doug

Hi Doug,

Probably the easiest way of doing this would be to use Red Gate's SQL Compare tool can perform the comparison against an empty database. Our dependency engine will then compute the order the tables need to be created in for you, you will be able to see this during the summary step in the synchronization wizard or by looking at the synchronization (which will actually be the creation) SQL directly.

Regards,

James
--
James Moore
Red Gate Software Ltd

Hmmmm?

Originally Posted by chrishirst

Hmmmm?

You know what is going on.

Oooooohh yesssss!

just can't quite prove it