I am in the process of finalizing the first release of Trac_Fu and something just occurred to me. During exporting the database scripts for SQLServer, I have no option for including INSERT statements for the default data.
I use PHPMyAdmin to export my MySQL scripts and I can include inserts for all of the default data that goes with the database. But when looking through the SQLManager 2005 client, I cant find anywhere to allow me to add the inserts, it only generates the scripts for the database objects themselves. I guess I’ve never really had a need for this feature on any application that I’ve built for MSSQL before.
My question is what tools to do you guys use for exporting your MSSQL databases with data into scripts?
I just realized that the default scripts that the 2005 client generates will not run in MSSQL 2000 either. I guess Im going to need a third party tool to export the MSSQL scripts so they will run on either version.
Let me know what you guys are using currently.