Script Alter Tables

  • Hi

    I Have a DB SQLServer2005

    Ineed Execut Changes to Other DB .

    How can I Generate Script Alter Tables Created ???

  • In management studio, right click on the database and go to tasks, generate scripts. Select the tables you want to script and thats about it. You get options to add keys/indexes etc as you go through.

  • If you are trying to script the database structure changes, we use Redgate SQL Compare to compare the development database against a reference database to generate a change script, then we roll those scripts to client locations.

    Its done really well for us for several years, on SQL 2000 and 2005.

    They also have a tool for comparing changes to the data in the tables, but I have no experience with that one.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply