Delete Analysis Services DB from command line

#1

I would like to delete an Analysis Services db from the command line instead
of going through the GUI. How can I do this?

#2

This is really simple.

Build a console C# application.
Add a reference to AMO (Microsoft.AnalysisServices ) to it.
All the code need in your application is something like:

Server ASserver = new Server();

ASserver.Connect("DataSource = MyServer;");

ASserver.Execute("<Delete
xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">
<Object><DatabaseID>MyDB</DatabaseID></Object></Delete>");

-----
This posting is provided "AS IS" with no warranties, and confers no rights

"Matt" <Matt (AT) discussions (DOT) microsoft.com> wrote

Quote:

I would like to delete an Analysis Services db from the command line
instead
of going through the GUI. How can I do this?

#3

I'm not really much of a programmer, and I've never used C# before. Is there
any other way of doing this?

"Edward Melomed [MSFT]" wrote:

Quote:

This is really simple.

Build a console C# application.
Add a reference to AMO (Microsoft.AnalysisServices ) to it.
All the code need in your application is something like:

Server ASserver = new Server();

ASserver.Connect("DataSource = MyServer;");

ASserver.Execute("<Delete
xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\"
Object><DatabaseID>MyDB</DatabaseID></Object></Delete>");

-----
This posting is provided "AS IS" with no warranties, and confers no rights

"Matt" <Matt (AT) discussions (DOT) microsoft.com> wrote in message
news:34882A99-B832-4BC8-A0EF-165AB68B6905 (AT) microsoft (DOT) com...
I would like to delete an Analysis Services db from the command line
instead
of going through the GUI. How can I do this?

#4

You can use SSIS to build a task that executes DDL against an AS connection
and use the <Delete> statement below. You can run the SSIS package on the
command line...

HTH,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Matt" <Matt (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm not really much of a programmer, and I've never used C# before. Is
there
any other way of doing this?

"Edward Melomed [MSFT]" wrote:

This is really simple.

Build a console C# application.
Add a reference to AMO (Microsoft.AnalysisServices ) to it.
All the code need in your application is something like:

Server ASserver = new Server();

ASserver.Connect("DataSource = MyServer;");

ASserver.Execute("<Delete
xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\"
Object><DatabaseID>MyDB</DatabaseID></Object></Delete>");

-----
This posting is provided "AS IS" with no warranties, and confers no
rights

"Matt" <Matt (AT) discussions (DOT) microsoft.com> wrote in message
news:34882A99-B832-4BC8-A0EF-165AB68B6905 (AT) microsoft (DOT) com...
I would like to delete an Analysis Services db from the command line
instead
of going through the GUI. How can I do this?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Delete Analysis Services DB from command line

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Delete Analysis Services DB from command line - 01-23-2006 , 08:15 AM

Re: Delete Analysis Services DB from command line - 01-24-2006 , 02:56 AM

Re: Delete Analysis Services DB from command line - 01-24-2006 , 06:40 AM

Re: Delete Analysis Services DB from command line - 01-24-2006 , 02:55 PM