+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Attaching legacy FMS database to SQL2012 instance in Technical; Morning All, We have an old legacy FMS database which we've just dbattach'd from our old SQL2008 server and are ...
  1. #1
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    597
    Thank Post
    101
    Thanked 42 Times in 40 Posts
    Rep Power
    19

    Attaching legacy FMS database to SQL2012 instance

    Morning All,

    We have an old legacy FMS database which we've just dbattach'd from our old SQL2008 server and are attempting to now attach it to a SQL2012 instance. Unfortunately I'm getting the following error "Could Not Find Stored Procedure 'sp_dboption" midway through the attach process. From the looks of things 'sp_dboption' is not longer supported on SQL2012 so how do we attach the database? Will doing it through the SQL Server Management Studio be sufficient? I also get the same error in the log file if I use the Migration tool on the backup DB Attach made when taking the original FMS DB off the older server.
    Last edited by Sam_Brown; 30th July 2014 at 11:54 AM.

  2. #2

    Join Date
    Apr 2007
    Location
    Cornwall
    Posts
    331
    Thank Post
    21
    Thanked 94 Times in 65 Posts
    Rep Power
    40
    Has this legacy database been kept up to date with new FMS releases as they come along? I'm thinking it hasn't...

    Meldrew.

  3. #3
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,116
    Thank Post
    720
    Thanked 174 Times in 157 Posts
    Blog Entries
    78
    Rep Power
    86
    It will need to be at the version of fms that first supported 2012, which I cant remember off the top of my head. If not, you will need to attach it to a 2008 instance, upgrade it and migrate it.

  4. #4
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    597
    Thank Post
    101
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    Quote Originally Posted by TheScarfedOne View Post
    It will need to be at the version of fms that first supported 2012, which I cant remember off the top of my head. If not, you will need to attach it to a 2008 instance, upgrade it and migrate it.
    Quote Originally Posted by Meldrew View Post
    Has this legacy database been kept up to date with new FMS releases as they come along? I'm thinking it hasn't...

    Meldrew.
    Yeah I assumed this was the issue and the solution! The problem is I don't believe we are paying for updates for FMS anymore as it is only being used as a legacy system. It gets accessed a few times a year if that. SOLUS only shows a few small patches and no major upgrades as being available. I guess it's a case of suck it up and keep the old server ticking along for FMS or purchase the upgrades and migrate over. I did try a straight "attach" using SQL Server but it won't let me log in to FMS after doing this. Am I right in thinking that's because the migration tool moves the users \ passwords over with it?

  5. #5
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,116
    Thank Post
    720
    Thanked 174 Times in 157 Posts
    Blog Entries
    78
    Rep Power
    86
    Fms user accounts have always been a bit of fun when changing servers. If you have done a dbdetach, this should bring everything with it. Heard of it not being right on a dbattach before tho. Definately wont like the sql way. Do you not still pay licence for fms? Your support entitlement would be worth checking ..its an interesting conundrum that one

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Quote Originally Posted by Sam_Brown View Post
    I guess it's a case of suck it up and keep the old server ticking along for FMS or purchase the upgrades and migrate over.
    Yup, otherwise you'll have the auditors all over you.

  7. #7
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    597
    Thank Post
    101
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    Quote Originally Posted by TheScarfedOne View Post
    Fms user accounts have always been a bit of fun when changing servers. If you have done a dbdetach, this should bring everything with it. Heard of it not being right on a dbattach before tho. Definately wont like the sql way. Do you not still pay licence for fms? Your support entitlement would be worth checking ..its an interesting conundrum that one
    I was planning on ringing them up today to check on our entitlement but they are on a "whole company training day"! I was under the impression we opted out of the FMS support and upgrades to save on a bit of money a while back but I will call the check in the morning.

  8. #8

    Join Date
    Oct 2013
    Posts
    18
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    3
    I have had the exact same issue in the past, Capita managed to get it sorted by making changes within SQL management studio although I cant for the life of me remember what they changed...but it can be done....sorry I couldn't be of more help!

  9. #9
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    597
    Thank Post
    101
    Thanked 42 Times in 40 Posts
    Rep Power
    19
    Gave them a shout the other day and they refused to budge because we don't have a support contract. Fair enough and what I expected. I asked how much just for the upgrades and they refused to do it as they were only prepared to offer it as part of a years full entitlement and support and wouldn't just offer us the upgrades. Bit shi**y but that's capita after all.

    In the end stuck SQL 2008 Express on the 2012 server alongside the SQL 2012 instance and works fine (after tweaking the TCP port).



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 3rd May 2013, 04:51 PM
  2. Replies: 1
    Last Post: 3rd October 2008, 12:36 PM
  3. Attaching FMS Database
    By mloveless in forum MIS Systems
    Replies: 0
    Last Post: 3rd June 2008, 04:39 PM
  4. FMS Upgrade to SQL and CFR reports
    By wesleyw in forum MIS Systems
    Replies: 0
    Last Post: 3rd April 2008, 09:58 AM
  5. Moving Sleuth database to another server.
    By Kyle in forum Educational Software
    Replies: 0
    Last Post: 10th December 2007, 11:05 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
  •