[dba-VB] SMO was Projects vs Solutions

Hi John --

OK, but why not just use connections strings and System.Data.SqlClient
classes, .... ?

Thank you.

--
Shamil

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Saturday, November 21, 2009 6:42 PM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] SMO was Projects vs Solutions

 > or do you plan to implement some custom applications using
Microsoft.SQLServer.* ?

Exactly.  My work for one of my clients is heavy manipulation of SQL Server.
I routinely export 
files to an external application running on virtual machines on another
server, then wait for the 
files to process, then import them back in to SQL server.  These two
processes together take about 
10 stored procedures.  The export / import has to occur on (currently) a
half dozen large databases 
monthly.  However as I obtain more lists that number goes up.  Each process
exports to it's own 
directory path, then imports back from a parallel directory path.  While the
stored procedures 
eliminate much of the manual labor, there is plenty left.  Plus logging of
everything etc.

I also routinely process orders.  These orders take about a dozen stored
procedures and also use the 
exact same set of stored procedures as the above process, i.e. the export /
import process is also 
used on each and every order.

So there is just a ton of very repetitive work that has to be done, but
which database / table 
varies from run to run.  To this point I have used Access / VBA to automate
these tasks.  Now I am 
moving to C# for this automation work.

SMO allows me to manipulate SQL Server from C# and so it is an API that I
will use to assist me in 
getting this program working.

John W. Colby
www.ColbyConsulting.com


Shamil Salakhetdinov wrote:
> Hi John --
> 
> Yes, I understand that.
> I'm wondering what for do you learning this stuff? - Just out of curiosity
> or do you plan to implement some custom applications using
> Microsoft.SQLServer.* ?
> 
> Thank you.
> 
> --
> Shamil
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Saturday, November 21, 2009 5:06 AM
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] SMO was Projects vs Solutions
> 
> That is used for manipulating the SMO object and SQL Server.
> 
> I am just learning this stuff and do what the demos tell me to do.
> 
> John W. Colby
> www.ColbyConsulting.com


 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4626 (20091120) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru