Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MSSQL backup conversion

Options
  • 30-07-2014 3:00pm
    #1
    curiousb
    Registered Users Posts: 486 ✭✭


    I host a website (asp/mssql) with a provider I wish to move away from. I have a backup of the database (.bak) which is a standard mssql backup format.

    However the host I want to move to uses mssql express edition and the backup won't restore to it. They say if I can convert the backup to plain SQL they can import it then.

    Is there a tool available whereby I can convert from .bak to .sql, using an offline backup file?

    Both hosts are shared hosting platforms so remote desktop access is impossible.

    I would really appreciate any suggestions.


Comments

  • Options
    #2
    Graham
    Moderators, Society & Culture Moderators Posts: 17,642 Mod ✭✭✭✭Graham


    If you still have access to the source database, could you use something like Navicat to export from MS SQL (as SQL)? If I remember correctly there's a 30 day free trial.


  • Options
    #3
    curiousb
    Registered Users Posts: 486 ✭✭curiousb


    I do, I'll give that a try thanks.


  • Options
    #4
    Beano
    Closed Accounts Posts: 3,357 ✭✭✭Beano


    If that doesnt work you can use the Generate Scripts option in SSMS that will generate scripts for both the schema and the data that you can use to recreate the database on your new server.


  • Options
    #5
    curiousb
    Registered Users Posts: 486 ✭✭curiousb


    Pardon my ignorance, but what is SSMS?

    I have installed Navicat, but don'r seem to have an SQL export option. csv, xml, xls are all there but no sql so far...


  • Options
    #6
    Beano
    Closed Accounts Posts: 3,357 ✭✭✭Beano


    curiousb wrote: »
    Pardon my ignorance, but what is SSMS?

    I have installed Navicat, but don'r seem to have an SQL export option. csv, xml, xls are all there but no sql so far...

    SQL Server Management Studio


  • Advertisement
  • Options
    #7
    Graham
    Moderators, Society & Culture Moderators Posts: 17,642 Mod ✭✭✭✭Graham


    It's listed under Data Transfer tools on the navicat website:

    http://www.navicat.com/products/navicat-for-sqlserver


  • Options
    #8
    TonyStark
    Registered Users Posts: 851 ✭✭✭TonyStark


    curiousb wrote: »
    I host a website (asp/mssql) with a provider I wish to move away from. I have a backup of the database (.bak) which is a standard mssql backup format.

    However the host I want to move to uses mssql express edition and the backup won't restore to it. They say if I can convert the backup to plain SQL they can import it then.

    Is there a tool available whereby I can convert from .bak to .sql, using an offline backup file?

    Both hosts are shared hosting platforms so remote desktop access is impossible.

    I would really appreciate any suggestions.


    What version of SQL is the .BAK file and what is your target version of SQL Server Express Edition?


  • Options
    #9
    Tow
    Registered Users Posts: 7,242 ✭✭✭Tow


    I have not used Developer/Express Edition for a new years, but from memory there was no difference between the data/file formats and the full version. As Tony asks, what are the version numbers of SQL. If they are different versions or your database exceeds limits or uses functionality which is not in the Express Edition you will have problems.

    When is the money (including lost growth) Michael Noonan took in the Pension Levy going to be paid back?



  • Options
    #10
    Yakuza
    Registered Users Posts: 5,141 ✭✭✭Yakuza


    Just a side note, Developer and Express are not the same thing; Developer has the same functionality as Enterprise (it costs €50) but is only licenced for development use and not production. Express is limited at 1GB RAM per instance and 10GB per database as well as other limitations.

    What versions are you moving from and to (not editions) 2005 to 2008/2012 etc?

    I'd either pick a different host that uses a proper edition of SQL Server, or you could install Developer yourself, import the backup, create a new DB (that has the same version as your target host) and give that to them.

    I'll repeat; a hosting option that uses SQL Express is probably a false economy, unless you just want a bare bones database in your application.


  • Options
    #11
    curiousb
    Registered Users Posts: 486 ✭✭curiousb


    Thanks for the replies. It is coming from 2012 and going to 2008 R2.


  • Advertisement
  • Options
    #12
    Tow
    Registered Users Posts: 7,242 ✭✭✭Tow


    curiousb wrote: »
    Thanks for the replies. It is coming from 2012 and going to 2008 R2.

    There is your problem, you are going backwards.
    I would be very reluctant to change from a provider who uses a full version to one with the free version, especially when their free version is a couple of revisions old.

    When is the money (including lost growth) Michael Noonan took in the Pension Levy going to be paid back?



  • Options
    #13
    curiousb
    Registered Users Posts: 486 ✭✭curiousb


    Ok, that makes sense. I have been able to export a backup using Navicat (thanks Graham), which is compatible with 2008 R2, so I will try an import and see how that works.

    The issue with hosts is the level of support to be honest. The current provider has a useless level of support, takes days to get replies to tickets and the one i am moving to is one I use for other sites and has great support so thats the main reason I am moving.

    The site is reasonably small with not a lot of traffic so hopefully it will run ok on the new server. I can put it on a VPS if necessary but am trying shared first.


Advertisement