cubes from sql2000 to sql2005 analysis services | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

cubes from sql2000 to sql2005 analysis services

hi,<br />i migrate my database from sql 2000 to sql 2005 succesfull.<br />but my problem is,how can i "transport" my projects in analysis services 2000 to sql 2005v analysis services <br />BUT<br />with changing the datasources for my cubes and dimension-i mean that i take the database,the cubes etc. to my new server and choose my new server as datasource.Old project in new sql20005 server tht i can turn off the sql 2000 completely?<br /><br />2.what happens with my virtual cubes???<br /><br />thanks [<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]
There is no more virtual cubes in sql 2005.
read this article on comparision between AS 2000 and 2005
thank you ranjitjain,
where is the article ?
[8D]
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by heiner</i><br /><br />thank you ranjitjain,<br />where is the article ?<br />[8D]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Sorry forgot to mention in hurry[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br />check this aricle shows thechanges in msas 2005<br /<a target="_blank" href=http://www.devx.com/dbzone/Article/21539>http://www.devx.com/dbzone/Article/21539</a><br /><br />this article shows the way to migrate msas 2000 db<br /<a target="_blank" href=http://www.databasejournal.com/features/mssql/article.php/3564291>http://www.databasejournal.com/features/mssql/article.php/3564291</a>
thank you a lot ranjitjain for your help,
but my problem is that i want to migrte the database and the cubes from server x (here the datasource is from the same server x) to server y and make the datasource server y !
and shut off the server x.
I hope i can explain it so-the article you send over there is very helpful but the datasource in that way is the same after migration.
wait for HEEEELP, PLEEEEAAAAAAAASEEEEEEEEEEEEEEEEEE
Nur so aus Neugierde. Hast Du das Thema auch schon mal in der deutschen SQL Server Newsgrouphttp://groups.google.de/group/microsoft.public.de.sqlserver angesprochen? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Hallo FrankKalis,
nein habe ich noch nicht-bin dort auch nicht fündig geworden.
]]>