+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Discover database to new server. process? in Technical; Hi, have moved SIMS and FMS databases onto a new server OK, but am now wondering what the correct process ...
  1. #1

    Join Date
    Aug 2011
    Location
    Bristol
    Posts
    30
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    7

    Unhappy Discover database to new server. process?

    Hi,

    have moved SIMS and FMS databases onto a new server OK, but am now wondering what the correct process for moving a DISCOVER database is. Have tried to attach the database using dbattach, but it just complains the ldf log file is missing, presumably because the file name is discover_log.ldf and not discover.ldf? Renaming and trying again produces a different error.

    I have tried to transfer data into a new DB, as if it was a fresh install, but at the moment the Discover Configurator is sat at waiting for service to respond. I am not sure if this is a separate issue or if something in the SIMS database from the old server already references a discover database and that's halting it.

    What's the correct procedure here?

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Use the Discover "Backup" tool in your SQL BINN folder, "backup" the data, install Discover on the new server - import the "backup".

    Pretty sure that's it.

  3. #3

    Join Date
    Aug 2011
    Location
    Bristol
    Posts
    30
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    7
    ah yes, I can see the backup gui in the summer release applications. We have yet to deploy the summer release.

    The database has been detached from the original server, so I'm not entirely surely how to export it to be imported into this new setup...

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Been told Discover shouldn't hold anything that can't be re-imported from SIMS. Not sure how true that is, I guess you'll find out.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I thought it stored all your config and customisations, preferences, rules, groups etc. I haven't installed it, just heard.

  6. #6

    Join Date
    Sep 2007
    Posts
    221
    Thank Post
    4
    Thanked 25 Times in 23 Posts
    Rep Power
    19
    Did you ever get this to work as im in the process of doing this at the moment ?

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    DBAttach won't attach discover or SOLUS3 .mdf and .ldf. Nor will it be able to restore a MSSQL backup.

    For discover, do a export using the Discover "backup" tool, install discover, import discover "backup"

    For SOLUS3 (i'm told):
    1) Shut down the old ds.
    2) Copy the S3 DB
    3) Installing the new ds and ds ui (if required)
    Existing ui's system config screen would need updating to the new ds machine name
    Existing ui's connection string would need to be modified by the connection string editor
    4) Re-registering the site so the security keys are sent to the new ds
    5) Updating DNS so that serverA redirects to serverB
    6) Shut down an online agent - check the status is set to offline
    7) Start the agent - check the status is set to online
    8) Uninstall the old ds.

    PS: I know you didn't ask about SOLUS3, but unless you fancy upgrading Discover manually each time, you'll need to use SOLUS3

  8. Thanks to matt40k from:

    woodham (26th October 2011)

  9. #8

    Join Date
    Sep 2007
    Posts
    221
    Thank Post
    4
    Thanked 25 Times in 23 Posts
    Rep Power
    19
    cool that worked for discover thanks

    Andy

SHARE:
+ Post New Thread

Similar Threads

  1. Migrate Ghost Suite to new server
    By HMCTech in forum Windows
    Replies: 3
    Last Post: 20th August 2008, 02:11 PM
  2. move mysql to new server
    By RabbieBurns in forum *nix
    Replies: 6
    Last Post: 20th June 2008, 05:48 PM
  3. Replies: 2
    Last Post: 8th March 2008, 02:18 PM
  4. Moving Sleuth database to another server.
    By Kyle in forum Educational Software
    Replies: 0
    Last Post: 10th December 2007, 10:05 AM
  5. Moving RIS images to new Server
    By Kyle in forum Windows
    Replies: 4
    Last Post: 11th October 2007, 12:18 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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