CMIS SQL server upgrade.

[dave-a]

Hi all a quick question for you. This summer we are upgrading are current CMIS and eportal server from a windows 2000 server and SQL-Server 2000 box to a new Windows 2003 server and SQL-Sever 2005 box. I would just like to ask anyone that has done this before how they did it, eg export database from sql 2000 and import into 2005.. and any problems they found in the upgrade.

 

Thanks in advance.

 

Dave.

[Guest monkeyx]

Although you could export data via SQL, it is easier to do a CMIS Admin backup and then restore that backup via CMIS admin.

 

I do this on a regular basis and have had no issues so far. You may need to recreate the DB user, if you runs under a different user from sa.

[CheeseDog]

Although you could export data via SQL, it is easier to do a CMIS Admin backup and then restore that backup via CMIS admin.

 

I do this on a regular basis and have had no issues so far. You may need to recreate the DB user, if you runs under a different user from sa.

 

Think I would do it this way too.

[Kained]

Same here do the backup and import through the app but take a sql backup as well, just in case