Solved

C++ API implementation of SQL SMO

Posted on 2007-12-06
2
1,053 Views
Last Modified: 2011-04-14
Is there a C++ implementation available for exposing objects in the Microsoft SQL Server Management Objects (SMO) dynamic link library SQLSMO.DLL?  As far as I can tell, SQLDMO cannot be used to manage instances of SQL Server 2005 and has been superceded by SQLSMO.  Thank you.
0
Comment
Question by:gssdev
2 Comments
 
LVL 86

Accepted Solution

by:
jkr earned 250 total points
ID: 20422250
It seems that there is nothing out there so far, see http://www.ftponline.com/vsm/2004_en/magazine/features/rjennings/page3.aspx ("Get Ready for SQL Server 2005"): "You program SMO and DMO operations with VS 2005 by adding .NET references to assemblies. COM wrappers support unmanaged VB, C++, and VBScript SMO programming."
0
 

Author Comment

by:gssdev
ID: 20449438
After some tweaks and turning on disabled options in SQL Server 2005 it so happens that SQLDMO does still function sufficiently to do what I need it to do.  Your response on SMO is what I expected though, I just don't have the time to build COM+ wrappers for those objects at this time.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question