Deployment Copy/Paste Problems

Hi all,
We maintain our CAB (meta-data only) in a source control system. The
process for deployment is simply to restore the CAB on the production
server and then copy/paste it to the production database name where it
will have it's final resting place.
By doing this we allow for scalability and robust management since the
same CAB can be deployed to many places. (In some places we process
different sets of cubes than in other places but the same meta-data
can be re-used.)
The problem we are finding is that one of our production servers is a
64 bit box that is (necessarily) remotely managed from a 32 bit
instance of Analysis Manager. When copy/pasting the database remotely
it takes a very, very long time to complete. Keep in mind that only
meta-data is being copied. When copy/paste is happening, it looks
like DSO code is executing to rebuild an entire database from scratch.
Does anybody have a faster method of copy/pasting an Analysis Services
database into place for deployment purposes?
Thanks,
DavidDavid Beavon wrote:

> Hi all,
>
> We maintain our CAB (meta-data only) in a source control system. The
> process for deployment is simply to restore the CAB on the production
> server and then copy/paste it to the production database name where it
> will have it's final resting place.
> By doing this we allow for scalability and robust management since the
> same CAB can be deployed to many places. (In some places we process
> different sets of cubes than in other places but the same meta-data
> can be re-used.)
>
> The problem we are finding is that one of our production servers is a
> 64 bit box that is (necessarily) remotely managed from a 32 bit
> instance of Analysis Manager. When copy/pasting the database remotely
> it takes a very, very long time to complete. Keep in mind that only
> meta-data is being copied. When copy/paste is happening, it looks
> like DSO code is executing to rebuild an entire database from scratch.
>
> Does anybody have a faster method of copy/pasting an Analysis Services
> database into place for deployment purposes?
> Thanks,
> David
http://www.solgenia.com/usa/Solutio.../SheetRubik.htm

Deploying SMO/RMO Applications to non-sql2005 servers.

Hi All,
Is it possible to deploy smo/rmo applications to servers and clients without installing the sql server 2005 client tools? Can I simply include the used assenblies or is there any dependance on some ActiveX objects or other configuration actions that must be performed for SMO/RMO to work?
regards,
Tore Birkeland
Yes, it is possible to deploy SMO/RMO applications without installing SQL Server 2005 client tools. The SQL Server 2005 RTM will include SMO redist setup file that you can use for your SMO-based applications. SMO relies on .NET Framework 2.0 and SQL Native Client.

deploying reports database to multiple servers

Hi,
i have some 35 customers, all of whom need a copy of the reports i have designed
how do i quickly and simply roll out my reports. the databases are generally , but not
always given the same name, and the user credentials will be different
but the reports need to be the same.

is this possible?

Regards,

Russ

You have two basic options:

1.) Script out creating the reports in the database and provide the scripts to your users.

2.) Detach your database, and give it to your users. They can then attach the database, and configure RS to use that database via the config tool. If they do this, they have to be sure to leave the name of the databases that same.

|||

Cheers John,

im wondering how easy it is to do option 1. is there an example available that you know of?

Regards,

Russ

|||

Try rdlscripter, it is very easy to do this.

http://www.sqldbatips.com/showarticle.asp?ID=62

deploying reports database to multiple servers

Hi,
i have some 35 customers, all of whom need a copy of the reports i have designed
how do i quickly and simply roll out my reports. the databases are generally , but not
always given the same name, and the user credentials will be different
but the reports need to be the same.

is this possible?

Regards,

Russ

You have two basic options:

1.) Script out creating the reports in the database and provide the scripts to your users.

2.) Detach your database, and give it to your users. They can then attach the database, and configure RS to use that database via the config tool. If they do this, they have to be sure to leave the name of the databases that same.

|||

Cheers John,

im wondering how easy it is to do option 1. is there an example available that you know of?

Regards,

Russ

|||

Try rdlscripter, it is very easy to do this.

http://www.sqldbatips.com/showarticle.asp?ID=62

Deploying reports and setting up reporting services on a clustered server

Hi

I have two questions:

1)

I need to deploy reports to a server in Spain, which I do not have direct access to. Is there any way that I can simply deploy the reports to a server here, that I have access to, and then copy the reports to the server in Spain? Or is there any other way? I cannot expect the customers in Spain to be able to use Microsoft Visual Studio 2005 themselves to deploy reports (they do not even have access to the tool).

2)

How do I set up reporting services on a clustered server? I have configured reporting services on both clusters, but somehow I cannot initialize both of them. Only on will be initialized at a time. Does anyone have experience with this?

Thanx :-)

Hello Heidi,

As for #1...

You can create the .RDL files from your machine, then place them in a location that the server in Spain has access to. Now, you can upload them into the reporting server via Report Manager. Select 'Upload File' from the menu bar in Report Manager, then navigate to the .RDL file and hit Ok.

For #2...

Are you trying to use an active/passive or active/active cluster? Here are a few links from Microsoft that might be able to help you.

http://msdn2.microsoft.com/en-us/library/ms157293.aspx
http://msdn2.microsoft.com/en-us/library/ms156453.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

Hope this helps.

Jarret