Script Alter Tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Script Alter Tables

Script Alter Tables

Rate Topic

Display Mode

Topic Options

Author

Message

mohamad_shafiei2003

Posted Monday, June 30, 2008 12:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, September 07, 2010 4:04 AM
Points: 1, Visits: 81

Hi
I Have a DB SQLServer2005
Ineed Execut Changes to Other DB .
How can I Generate Script Alter Tables Created ???

Post #525744

Animal Magic

Posted Monday, June 30, 2008 2:17 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 9:08 AM
Points: 983, Visits: 13,350

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.

Post #525766

wayne.mcdaniel

Posted Tuesday, July 01, 2008 8:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:27 PM
Points: 194, Visits: 535

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.

Post #526667

« Prev Topic | Next Topic »

Permissions