Programmatically Script out database objects to a previous version of SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Oscar D Garcia » Programmatically Script out database objects...

Programmatically Script out database objects to a previous version of SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

md7654

Posted Wednesday, March 25, 2009 2:07 PM

Forum 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 »

Permissions