FWIW, I'm in the process of writing (well, it's probably more accurately one of those things that "works, but will never really be done") a CF8 script that rips through a database, creates insert statements (option to include truncate statements and also sets identity insert on/off), and saves the results as an SQL script. Requires CF8 and so far only works with MS SQL Server, but if you're interested, email me and I'll send you the cf code when I get home. This, combined with the generate scripts option in the tasks menu in MS SQL Server Management Studio, should get you where you need to go. I just wish there was a system stored procedure that would create the table structure, which would allow me to do this all in one script.
Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
