Just wanted to start a discussion on a database issue that I am presented with; the issue is that I am trying to insert seed data into around 90 tables without having to worry about manipulating/disabling the foreign key constraints.
The most logical solution would be to do disable them during downtime or when the application has been brought down, insert the seed data and then re-enable the foreign keys. This solution will not work since say the application needs to be up and online while the inserts/updates are happening.
My intial thought was to use the 'sys.foreign_keys' command and store those into a temp table and thus the reference the data relationships when the inserts are executing. Is this a viable option .. or are there any better/more efficent solutions out there?