Post reply

Script Alter Tables

  • June 30, 2008 at 12:33 am

    #209209

    Hi

    I Have a DB SQLServer2005

    Ineed Execut Changes to Other DB .

    How can I Generate Script Alter Tables Created ???

  • June 30, 2008 at 2:17 am

    #835997

    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.

  • July 1, 2008 at 8:18 am

    #836713

    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