+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Sims testing enviroment? in Technical; I want to set up a Sims testing enviroment, where I can pull an image of what is currently in ...
  1. #1
    RichB's Avatar
    Join Date
    Oct 2008
    Location
    A Nice School
    Posts
    399
    Thank Post
    142
    Thanked 51 Times in 38 Posts
    Rep Power
    71

    Exclamation Sims testing enviroment?

    I want to set up a Sims testing enviroment, where I can pull an image of what is currently in sims and then export it to Virtual Pc machine or something like this where the admin team can play around with sims and not break the real one?

    Can this be done? and if so how?

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,256
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    174
    Live data or training data.

    Either way you can Restoreui a backup or DBAttach/deattach databases.

    I often bring school data onto my PC to test.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Yep, more and more people do this now.
    Search the forums for instructions on moving SIMS server, the principle is the same, except you carry out all tasks on the VM.
    Essentially, set up a VM as you want with Windows, SQL, then restore a backup of SIMS from the live server on to it.
    Copy over the Document Management Store. Rename the file to it and change the setting in SIMS to point to it. Alter the connect.ini to point to new server and you're away.
    I usually label the Virtual in the shared folder to say it's a test server, also map a different drive to it, and call it something else e.g. SIMSTestServershare so that there can be no issues with people connecting to the live server. when i say people i mean, me, as i don't let others use it.

  4. #4

    Join Date
    Oct 2008
    Location
    Lancashire
    Posts
    18
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We're trying to set up a test sims server before moving sims to a new server. If we start with a Windows 2003 server, which has no apps on it, what is the order of installation for SIMS and SQL server? Does it matter which way around these are done? We have tried putting sims on and sql server but cannot log in to sims and cannot locate the original sims instance in SQL Server Management Console. We didn't detach the database on the original server before copying it over, but did stop the sql server. Thanks, Phil

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    Fully patch Windows 2k3 server
    Install SQL (i'm assuming you're using 2005 - best to stick with that for your test, you can do another test when you're confident to move to SQL 2008 which is needed by October) and fully patch. When installing, choose a named instance, SIMS2005 is one of the norms.
    Install SIMS, usually, running simsinst and selecting options to make it a server / doc store.
    You should detach the original db and copy to the new server, then reattach. Using dbattach, this backs up all the usernames and passwords into the sims mdf. ( i think i'm right with this).
    Otherwise, your passwords etc are stored in your master table which you wont have taken over.
    I actually, just take a .bak backup file created by SQL management studio and restore to the server, but i'm usually just adding to an existing test install, so not sure if you could do that for a fresh install.

  6. #6

    Join Date
    Oct 2008
    Location
    Lancashire
    Posts
    18
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for the advice. We are planning to do this tomorrow. We orginally set this up in the reverse order so maybe second time lucky! Phil

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,641
    Thank Post
    685
    Thanked 1,400 Times in 1,160 Posts
    Rep Power
    353
    good luck

  8. Thanks to vikpaw from:

    philserre (19th May 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS SQL Migration testing...
    By Rawns in forum MIS Systems
    Replies: 0
    Last Post: 11th February 2010, 09:42 AM
  2. Entering Virtual Enviroment - Questions
    By ahuxham in forum Thin Client and Virtual Machines
    Replies: 8
    Last Post: 19th August 2009, 11:16 PM
  3. QCA Testing - Admin Point System - Import from SIMS
    By andy_d in forum Educational Software
    Replies: 10
    Last Post: 22nd May 2009, 08:29 AM
  4. User Enviroment corrupted
    By macca in forum Windows
    Replies: 1
    Last Post: 28th January 2008, 01:01 PM
  5. Bootcamp enviroment in school
    By Rozzer in forum Mac
    Replies: 35
    Last Post: 26th August 2006, 10:00 PM

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
  •