DataBase Conversion to 8.1

Question

I am looking at upgrading from v7.8.5 to v8.1.  Our current database is around 40GB in size and sits on a separate SQL cluster.  I was looking at formulating a plan to best handle this conversion.

One of my concerns is that the SQL cluster were the database resides has several other production databases that reside on the same cluster.  The cluster disk storage is EMC SAN however I am concerned that the other databases will take a performance hit during the Orion database conversion process.

Does anybody else have experience with doing the Orion database conversion on a SQL cluster that has other production databases on it?  Did they take a performance hit during the conversion process?

During this process I have a brand new Server that I am going to install Orion on.  One question I have is if I copy the .mdf and .ldf files over to this new server can I run the database conversion on this new server (recognizing the disk storage requirements) if I do not have SQL server installed on this new server?  Basically I would copy the files over to the new Orion server run the database conversion and then copy the database files back to the SQL cluster.  Does this make sense?

Thanks,

vhcato · Answer

In any case, the DB in V8.1 cannot read the 7.8.5 DB, so the only way to do this is upgrade the old server & DB to 8.1, before moving it onto the new hardware. Once you have successfully upgraded your old server & DB to 8.1 & have tested it from the web GUI, backup the DB & restore it on your new 8.1 DB server.

NG,

Have you actually tried to move the 7.8.5 DB to the new server and run the 8.1 Config Wizard against it? I thought this would work, but if not, that's a real bummer. That means down time, whereas I was hoping to build out the new 8.1 installation in parallel.

Network_Guru · Answer

I am doing something similar - upgrading server hardware & Orion software, as well as adding a second polling engine.

I am building a new 64bit Orion & SQL2005 DB server on new hardware & want to make my existng all-in-one web/polling/DB Orion server in a secondary polling server. (I'm not sure I can mix 64bit & 32bit server polling engines).

In any case, the DB in V8.1 cannot read the 7.8.5 DB, so the only way to do this is upgrade the old server & DB to 8.1, before moving it onto the new hardware. Once you have successfully upgraded your old server & DB to 8.1 & have tested it from the web GUI, backup the DB & restore it on your new 8.1 DB server.