We will soon have a new server up and running with SQL 2000 and Analysis Services.
The server we are currently using has SQL 7 and OLAP on it along with all of our current databases. My question is, will the switch go smoothly from OLAP to AS when we bring up this new server? At the same time, will the transition of SQL 2000 go well? Will we need to do anything to the current databases so we don't lose months of work in OLAP?
Thanks for any comments in advance.
The server we are currently using has SQL 7 and OLAP on it along with all of our current databases. My question is, will the switch go smoothly from OLAP to AS when we bring up this new server? At the same time, will the transition of SQL 2000 go well? Will we need to do anything to the current databases so we don't lose months of work in OLAP?
Thanks for any comments in advance.