SMO with VBS to script DB Objects
-
I posted this in the programming forum, but it's really an Admin issue so maybe someone has some insight:
I don't know much about VBS and even less about VB.NET but I need to write a script that will script out database objects
. If anyone has done this with SMO, please, please post some examples. MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
MG,
SMO is a managed assembly so you cannot use VBS. Sorry. You'll have to use a .Net language to use SMO. You can use Management Studio to script database objects. If that's not an option there are several SMO samples available in the core product. Check out Books Online for how to install the samples. Also in Books Online there is a list of the SMO samples.
Michiel Wories was the PM behind SMO. Check out his blog (http://blogs.msdn.com/mwories/default.aspx) for more information on SMO.
Best of Luck,
Dan
-
Just a PS to this item:
The Backward Compatibility feature lets me capture all the things I need. using VBScript and SQL DMO. I would imagine that this feature won't go away anytime in the forseeable future (hopefully never) so it bought me some time to either learn VB.Net or C#.Net
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
Thats a good enough solution! We'll work on getting a few SMO articles published, not much out there on it so far. Has some very nice features compared to DMO.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply