Automated SQL Script Generator

[btturner]

Anyone know of a product / utility which will allow a user to selectively create SQL Scripts to build SQL objects?

Our development team architect wants the capability to dynamically select any object (table, view, sp, etc) and generate script to be dynamically imbedded in his nitely deployment process.

He is NOT interested in manually generating SQL Scripts from E/M.

Ideas, experiences here?

 

[SQLSister]

I never heard of a tool that can do this unattended. SQLCompare has the ability to compare two databases and script the differnces, but even with it you cannot do it unattended or you will run into problems. For instance suppose a change is made that adds a new table Orders which has a foreign key constraint to the Products table which is also a new table. A script would proably create these objects in alphabetical order, but you cannot run the script for the first without the second being created first because it can't create the foreign key without the field and table being in existence. And sometimes you have things in the development database that are not yet ready to be sent to the other database becasue they are not yet finished and ready to be part of the build. I also have many things in my development databases which are not ever intended to go to production or staging because they are holding tables involved with the import of data. I can't even imagine how anyone would do a build automatically for a database without human intervention.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief