+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, CMIS SQL server upgrade. in Technical; Hi all a quick question for you. This summer we are upgrading are current CMIS and eportal server from a ...
  1. #1

    Join Date
    May 2007
    Location
    Liverpool
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    CMIS SQL server upgrade.

    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.

  2. #2
    monkeyx's Avatar
    Join Date
    Nov 2006
    Posts
    364
    Thank Post
    8
    Thanked 52 Times in 41 Posts
    Rep Power
    25

    Re: CMIS SQL server upgrade.

    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.

  3. #3
    CheeseDog's Avatar
    Join Date
    Jan 2006
    Location
    West Midlands
    Posts
    217
    Thank Post
    5
    Thanked 2 Times in 2 Posts
    Rep Power
    18

    Re: CMIS SQL server upgrade.

    Quote Originally Posted by 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.
    Think I would do it this way too.

  4. #4

    Join Date
    Feb 2007
    Location
    Lincolnshire
    Posts
    120
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: CMIS SQL server upgrade.

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

SHARE:
+ Post New Thread

Similar Threads

  1. CMIS Upgrade to 2.81.8.0
    By limbo in forum MIS Systems
    Replies: 41
    Last Post: 17th May 2007, 11:28 AM
  2. CMIS Upgrade 2.8.???.? to 2.8.40.1
    By DaveP in forum MIS Systems
    Replies: 16
    Last Post: 24th March 2007, 11:05 AM
  3. new server or bits of server upgrade?
    By amyr in forum Hardware
    Replies: 26
    Last Post: 12th March 2007, 12:52 PM
  4. CMIS problems with latest upgrade warning
    By SpuffMonkey in forum MIS Systems
    Replies: 7
    Last Post: 22nd June 2006, 06:10 AM
  5. Hel with CMIs/ePortal upgrade please.
    By tosca925 in forum Educational Software
    Replies: 5
    Last Post: 11th January 2006, 09:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •