Dynamically adding new objects

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Dynamically adding new objects

Postby kevine323 » Wed Feb 29, 2012 12:06 am

Does the command line interface support running a project file and that project picking up new tables or stored procedures that have been created since the project file was last opened in the UI?
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
kevine323
 
Posts: 39
Joined: Thu Jul 27, 2006 10:23 pm

Postby David Atkinson » Mon Mar 05, 2012 5:50 pm

Kevin,

If you save a project, and subsequently objects are added, these should be included by default in the project.

Let us know if this isn't working as expected for you.

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby kevine323 » Mon Mar 05, 2012 8:23 pm

It seems to have worked correctly with the command line and the /alldbs flag set. However, it did have a problem with a database that I had set to OFFLINE since the last time the project file was opened in the UI.
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/
kevine323
 
Posts: 39
Joined: Thu Jul 27, 2006 10:23 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests