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 ...
24th August 2011, 04:55 PM #1
IDG Tech News
25th August 2011, 11:51 AM #2
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.
25th August 2011, 02:58 PM #3
- Rep Power
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...
25th August 2011, 03:02 PM #4
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.
27th August 2011, 01:13 PM #5
I thought it stored all your config and customisations, preferences, rules, groups etc. I haven't installed it, just heard.
26th October 2011, 12:09 AM #6
- Rep Power
Did you ever get this to work as im in the process of doing this at the moment ?
26th October 2011, 09:31 AM #7
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
Thanks to matt40k from:
woodham (26th October 2011)
26th October 2011, 10:28 AM #8
- Rep Power
cool that worked for discover thanks
By HMCTech in forum Windows
Last Post: 20th August 2008, 03:11 PM
By RabbieBurns in forum *nix
Last Post: 20th June 2008, 06:48 PM
By Sunshine in forum Scripts
Last Post: 8th March 2008, 03:18 PM
By Kyle in forum Educational Software
Last Post: 10th December 2007, 11:05 AM
Last Post: 11th October 2007, 01:18 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread