Results 1 to 13 of 13
  1. #1
    Join Date
    Oct 2003
    Location
    Haxorland
    Posts
    7,103

    IT Mags - updating SQL database MDF file

    I know a couple of you know how to do this. I have a SQL database that needs to be updated/upgraded from sql 2008 to 2017. I imagine it is a very simple procedure, but I'm not familiar with it and my IT department is mostly non-responsive until you tell them exactly what you need and how to do it.

    From what I've found so far, it seems like you just need to open and close it from the SQL server manager. Is that it?
    I've concluded that DJSapp was never DJSapp, and Not DJSapp is also not DJSapp, so that means he's telling the truth now and he was lying before.

  2. #2
    Join Date
    Sep 2004
    Location
    champlain valley
    Posts
    5,656
    really big picture - back the database up and restore on new sql server

    it will be running at the 2008 compatibility level. this is probably what you want if you have applications running on it that aren't upgraded to run on the SQL version of the new server

  3. #3
    Join Date
    Oct 2003
    Location
    Haxorland
    Posts
    7,103
    Quote Originally Posted by DBdude View Post
    really big picture - back the database up and restore on new sql server

    it will be running at the 2008 compatibility level. this is probably what you want if you have applications running on it that aren't upgraded to run on the SQL version of the new server
    It's the other way around. We upgraded our application and it required us to upgrade from SQL 2008 to run the new software.
    I've concluded that DJSapp was never DJSapp, and Not DJSapp is also not DJSapp, so that means he's telling the truth now and he was lying before.

  4. #4
    Join Date
    Sep 2008
    Location
    a poop plant
    Posts
    3,363
    Fuck IT departments. This exact issue is why we're moving more and more to SAS. Can't get those guys to do shit. And when they do they fuck it up. I'm two years behind on a major enterprise wide application because they can't seem to upgrade the SQL.

    Start moving all your stuff to the cloud and have the real pros take care of it.

  5. #5
    Join Date
    Sep 2004
    Location
    champlain valley
    Posts
    5,656
    Quote Originally Posted by DJSapp View Post
    It's the other way around. We upgraded our application and it required us to upgrade from SQL 2008 to run the new software.
    Ok - then run a sql script on the database to set the compatibility to the correct level

    Put in a support ticket with the vendor and ask for the upgrade documentation


    Sent from my iPhone using TGR Forums

  6. #6
    Join Date
    Sep 2004
    Location
    champlain valley
    Posts
    5,656
    you really should do all this in test first...

  7. #7
    Join Date
    Mar 2012
    Location
    The Bull City
    Posts
    14,003
    +1 to having a back up (or two) before attempting that kind of upgrade.
    Go that way really REALLY fast. If something gets in your way, TURN!

  8. #8
    Join Date
    Nov 2006
    Location
    NCW
    Posts
    4,579
    Move to AWS while you’re at it and can the IT staff if they can’t figure out dba basics.

  9. #9
    Join Date
    Oct 2003
    Location
    Haxorland
    Posts
    7,103
    Quote Originally Posted by DBdude View Post
    you really should do all this in test first...
    It's in test and we're playing with backups. We're dumb, not stupid.
    I've concluded that DJSapp was never DJSapp, and Not DJSapp is also not DJSapp, so that means he's telling the truth now and he was lying before.

  10. #10
    Join Date
    Oct 2003
    Location
    Switzerland
    Posts
    7,578
    Quote Originally Posted by DBdude View Post
    you really should do all this in test first...
    Living on the edge!


    DJ, what about new SQL licenses? Included with the app software or purchased separately?

    Does performance matter for this app? How large is the db and how many users? Physical server or Vm? What kind of disks? Sql on the same sever as the app? (Not good)

    Make sure at least to set min/max memory on SQL do you don't overallocate on your server. Leave at least 4gb free for the opsys.



    Sent from my SM-A505FN using Tapatalk

  11. #11
    Join Date
    Aug 2016
    Location
    No longer Alexandria, VA
    Posts
    2,648
    Name:  8d0ccac18247b6a14d83309f49c08d05e2dd52ffb744a635366e4a726be3593f.jpg
Views: 162
Size:  61.1 KB

  12. #12
    Join Date
    Oct 2003
    Location
    Haxorland
    Posts
    7,103
    The IT gang got it done last night. Thanks all.
    I've concluded that DJSapp was never DJSapp, and Not DJSapp is also not DJSapp, so that means he's telling the truth now and he was lying before.

  13. #13
    Join Date
    Dec 2012
    Location
    I can still smell Poutine.
    Posts
    24,508
    Quote Originally Posted by thefortrees View Post
    Name:  8d0ccac18247b6a14d83309f49c08d05e2dd52ffb744a635366e4a726be3593f.jpg
Views: 162
Size:  61.1 KB
    This.

Posting Permissions

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