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

Getting Data out of SQL Server from Powershell Expand / Collapse
Author
Message
Posted Thursday, January 1, 2009 8:52 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:13 AM
Points: 259, Visits: 713
Comments posted to this topic are about the item Getting Data out of SQL Server from Powershell


Post #628576
Posted Friday, January 2, 2009 6:27 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:40 AM
Points: 588, Visits: 2,554
Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on it? It would seem a reasonable thing to want to do.


Best wishes,

Phil Factor
Simple Talk
Post #628759
Posted Friday, January 2, 2009 10:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:13 AM
Points: 259, Visits: 713
Phil Factor (1/2/2009)
Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on it? It would seem a reasonable thing to want to do.


Yes, SMO is redistributable and is available as a separate installation outside of SQL Server Management Studio (SSMS):

[url=http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&DisplayLang=en][/url]






Post #628952
Posted Friday, January 2, 2009 10:26 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 3, 2014 1:37 PM
Points: 298, Visits: 999
It appears that the SMO components may be redistributable. The Management Objects package is freely available from Microsoft's site (as part of the Feature Pack for Microsoft SQL Server 2005 (http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en) or Feature Pack for Microsoft SQL Server 2008 (http://www.microsoft.com/downloads/details.aspx?familyid=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en)

Additionally, there is a blurb contained within the verbiage of the download page which reads:


Download the appropriate file by clicking one of the links below, then run the downloaded file to install that package.
Each package indicates the audience(s) for which it was intended, as follows:

Customer: An individual may want to install this for additional licensed functionality such as interoperability.
Partner: An ISV may want to ship this as a redistributable component as part of their application.
Developer: A programmer may want to install this to support application development.


So it looks good for SMO being redistributable.


-- J.Kozloski, MCDBA, MCITP
Post #628958
Posted Friday, January 2, 2009 10:33 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:40 AM
Points: 588, Visits: 2,554
Thanks both of you for the info. That was very helpful, and makes the SMO solution look very attractive.


Best wishes,

Phil Factor
Simple Talk
Post #628963
Posted Friday, January 2, 2009 10:41 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, October 2, 2014 12:09 PM
Points: 4,358, Visits: 9,538
Phil Factor (1/2/2009)
Is the SMO library freely-distributable? What would happen if you created a Powershell application using SMO, and then wanted to install it on a computer that didn't have SSMS on it? It would seem a reasonable thing to want to do.


Yes, you can download the management objects separately. You get them from the feature pack downloads for the version you are using. For example, SQL Server 2005 feature packs can be found at: http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #628971
Posted Friday, January 2, 2009 10:45 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,406, Visits: 1,400
Nice article...:)


Post #628976
Posted Friday, January 2, 2009 12:19 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:14 AM
Points: 9,294, Visits: 9,483
Thanks Chad, this is great.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #629023
Posted Saturday, January 3, 2009 11:16 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
Good article Chad,

You hear about these things and don't have time to look into them, then someone comes along and writes a nice concise article demonstrating a real cool tool.

Thanks,


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #629314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse