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

Programmatically Script out database objects to a previous version of SQL Server Expand / Collapse
Author
Message
Posted Wednesday, March 25, 2009 2:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 30, 2010 10:53 AM
Points: 1, Visits: 12
Hello All,
Via a vb.net app I am extracting SQL2005 objects which will in turn be run into a sql2000 database.

SQL Server Management Studio's \Task\Generate Script has an option where I can set the output to a SQL2000 format.

Do any of the DMO objects have a property which can be set so I can generate a SQL2005 object's script to a SQL2000 format from within VB.NET?

Thanks, in advance, for any assistance you can offer.
Post #683660
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse