Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script Alter Tables Expand / Collapse
Author
Message
Posted Monday, June 30, 2008 12:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 7, 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
Posted Monday, June 30, 2008 2:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:34 AM
Points: 1,001, Visits: 13,533
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
Posted Tuesday, July 1, 2008 8:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 30, 2014 8:32 AM
Points: 194, Visits: 547
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 »

Add to briefcase

Permissions Expand / Collapse