Post reply

Import DB from MS SQL 2012 to from MS SQL 2008

  • May 15, 2018 at 7:27 am

    #338048

    Hi,
    Can anyone shed some light on how to import MS SQL 2012 Database Structure to MS SQL 2008 with sequential dependency order?

    Regards,
    Samuel

  • May 15, 2018 at 7:40 am

    #1990518

    msamueldcosta - Tuesday, May 15, 2018 7:27 AM

    Hi,
    Can anyone shed some light on how to import MS SQL 2012 Database Structure to MS SQL 2008 with sequential dependency order?

    Regards,
    Samuel

    Probably the easiest way is to use the Generate Scripts task in SSMS, Right click on the database, tasks, generate scripts. Script entire database and objects and make sure to go to the advanced settings on the Specify how scripts should be saved or published. Check the settings and also check the Script for Version setting and set it to 2008.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply