Migrating From Development to Production Environment in MSAS 2005

Hi,

I have built a project in Ananlysis Services 2005 and would like to migrate the contents of the Project ( Dimensions, Measures, Cubes Etc) to a New server having analysis Services 2005 , what is the best approach. Does microsoft provide any best practices document. I searched the forum and the topics on migration seem to be from Analysis Services 2000 to Analysis Services 2005, can some one guide me on migration between Analysis Services 2005 and 2005.

Thansks

A backup and restore (like in AS2000) is certainly possible. This is the only method if you need to get the data cube moved in a processed state (with data). Except you could use the new synchronization feature, but that would probably be using this feature for something it was not quite intended.

The recommended method would be using the new AS Deployment Wizard. Make a "build" in BI Development Studio of your database and fire up the AS Deployment Wizard. This will allow you to specify different settings for your cube database when it is deployed to the production server. For more info on how to use the Deployment Wizard, see http://msdn2.microsoft.com/en-US/library/ms176121.aspx

Migrating from ASP

I have a bunch of contracts built in asp and I need them to be

published on report server. Is there any easier way than rebuilding

them in report designer?

There is not migration path from ASP to Reporting Services reports. You can store the asp contracts in reporting services as resources, but they will not be executed as reports.

Migrating a db from SSE 2005 December CTP to SSE 2005 Release Version

I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:

1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.

2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.

3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.

Any other ideas where I can go with this at this time?

Thanks in advance.

Bill

Often the easiest way to move databases is to do a Backup and Restore.|||

As you can see from # 2 of my attempts at this, that didn't work. Actual error was:

Database 'xyz' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (.Net SqlClient Data Provider)

|||

December CTP of what year? 590 is a pre-RTM version of SQL Server from well over a year ago. There is no way to upgrade this database to the current SP2 version, in fact I don't believe you could even open this database in RTM. The only way to move this database would be to go back to the version where it was created, script the database out to T-SQL and run the scripts on a released version of SQL Server.

Mike

sql

Migrating a db from SSE 2005 December CTP to SSE 2005 Release Version

I have a developer who built an application using the SSE 2005 December CTP and I would like to bring the db's into the official SSE 2005 released version. I have attempted the following:

1. Create the db's in the released version, detach and re-attach the CTP db's. I got an error telling me they were incompatible.

2. Installed CTP version on one server, backed up the db's and then attempted to restore the db's on another server running the official released version of SSE 2005. Got an error attempting that too.

3. Installed the Management Studio for SS 2005 Developer edition thinking that I could connect to the two seperate instances of each server and like I could in EM 2000 run the transfer wizard to move the db's and data from one server to the next. Problem with this is that I can't get an object browser connection established. I have TCP/IP all config'd correctly, too.

Any other ideas where I can go with this at this time?

Thanks in advance.

Bill

Often the easiest way to move databases is to do a Backup and Restore.|||

As you can see from # 2 of my attempts at this, that didn't work. Actual error was:

Database 'xyz' cannot be upgraded because its non-release version (590) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. (.Net SqlClient Data Provider)

|||

December CTP of what year? 590 is a pre-RTM version of SQL Server from well over a year ago. There is no way to upgrade this database to the current SP2 version, in fact I don't believe you could even open this database in RTM. The only way to move this database would be to go back to the version where it was created, script the database out to T-SQL and run the scripts on a released version of SQL Server.

Mike

microsoft.reporting .rdlc

Hi I am trying to make a scatter chart with the reportviewer and report built into Visual Studio 2005

In my dataset it's basically a date and a value like

3/2/2005 10000

3/4/2005 12000

3/7/2005 9000

So I set the chart to use the Date on the X axis and the number on the Y axis

the report generates but on the X axis all the dates are converted to some integer value and it doesn't display it in date format, how do i get it to show in date format?

I think it takes the date and makes it an integer so it can display all the ticks for it for the dates that are not in my dataset that lie inbetween the dates that are.

Hii, I dont know what chart you are using, but you will have to use the CustomProperty in the charts <CustomProperties>,

For dundas chart the rdl looks like this -

<CustomProperties>

<CustomProperty>

<Name>Chart.ChartAreas.0.ChartArea.AxisX.ValueType</Name>

<Value>Date</Value>

</CustomProperty>