MIS Systems Thread, SIMS SQL 2005 --> 2008 migration in Technical; I'm just in the planning stages of moving SIMS from SQL 2005 to SQL 2008 (both full versions not express). ...
26th July 2010, 01:45 PM #1
SIMS SQL 2005 --> 2008 migration
I'm just in the planning stages of moving SIMS from SQL 2005 to SQL 2008 (both full versions not express). At one point the documentation says "In order for the redirection service to operate, SQL 2005 must be left running for a suitable period of time, i.e. until all users have logged into SIMS." As I'm performing the upgrade early in the summer holiday most staff won't login for a long time. How essential is this part of the process and what does it actually change for each user?
If you need more details ask away.
Oh I think I've found an explanation now it remaps the connect.ini file to the new instance name.
Last edited by cookie_monster; 26th July 2010 at 02:05 PM.
26th July 2010, 02:10 PM #2
That's what i was going to say. I couldn't see much that the redirection does because if you do a server to server migration, you need to alter the Docstorage location, and also change the connect.ini files.
so if you have the shared connect.ini setup, you only need to change it in one place.
i guess the redirection service is that if you have users with their own connect.ini that points to the old server instance, then it triggers something that points to the new server and changes the connect.ini, but if you make sure they are changed it should be fine, or worst case someone can't log in and needs a new connect.ini
that's how i've read it anyway.
Thanks to vikpaw from:
cookie_monster (26th July 2010)
26th July 2010, 03:04 PM #3
Ok I'm pretty sure that all of our stations use the connect.ini file that's on the S:\ drive so that shouldn't be a problem. If I install SQL 2008 alongside 2005 and then use the migration tool but don't allow it to install SQL express that all that should be left to do is remap the document store. Is that right?
26th July 2010, 03:10 PM #4
the redirect service should do that for you and it's a one off thing, but i may be mistaken on that part.
26th July 2010, 03:16 PM #5
Ok cheers, I'll be having another read through the documentation before beginning
29th July 2010, 09:47 AM #6
- Rep Power
I've just migrated from Sql 2005 to Sql 2008 with no problems. Ive also just updated to summer release.
My question is, we have SLG, what do I need to alter for it to work now I've migrated to SQL 2008? It's hosted by Capita. Is there a config file on my server I need to point to the 2008 sql location?
29th July 2010, 10:03 AM #7
When we migrated last February it coincided with a move to a new SIMS server at the same time. We had to get Capita to do the reconfiguration on the new server. We are Capita SLG Hosted as well and we obviously do not have the Passwords to Capita's servers. We were charged, but that may have been more to do with moving SIMS Servers at the same time.
Originally Posted by IT_Man_Dan
29th July 2010, 02:24 PM #8
Contact Capita asap. ADP will need reconfig at the very least. In hosted environments is that off site too, or is the service run locally? If it's local, you may be able to change something.
Originally Posted by IT_Man_Dan
By teejay in forum MIS Systems
Last Post: 21st November 2010, 07:50 PM
By chazzy2501 in forum General Chat
Last Post: 30th April 2010, 11:31 AM
By matt40k in forum MIS Systems
Last Post: 8th August 2009, 12:08 AM
By Ric_ in forum MIS Systems
Last Post: 29th February 2008, 02:06 PM
By mullet_man in forum MIS Systems
Last Post: 23rd November 2007, 06:03 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)