There was a application which, earlier, pointed to a database. It used a specific set of tables. Those tables had triggers, constraints, etc. There were also stored procs which insert data into these tables.
There was a new application built on the same lines (with minimal changes), but to make that application work in our test box, we had to backup the existing database, and restore that one with a different name. The new app database pointed to this newly restored db.
But the restored db has objects which were totally unnecessary.
Now I am faced with the task of creating deployment scripts that should run in our production box, and create the database (with the required objects for the new app to work).
Are there any tools that would make this job easier?
PS: My test box has a sql server 2005 db. Where as the production box has a sql server 2000 db.