Import SQL Server 2008 Database to SQL Server 2014

Yatendra Singh Yatendra Singh Updated On - 07 Nov 2019

With a post published on July 12, 2018, Microsoft announced in context to the support for SQL Server 2008 & SQL Server 2008 R2. Emphasizing on end of support for SQL Server 2008 & Windows Server 2008, the post walks you on why the company is dropping the support and why you should choose the next better offered by the giant, learn more about the details from here. With the completion of the 5-year lifecycle for both regular & security updates for the mentioned tools, issues such as security risk from cyber-attacks, compliance risks, performance, efficiency, and more will be up after the support end, as briefed below.

Thus, if you’re still making use of SQL Server 2008 or SQL Server 2008 R2, you’ve still got time to plan your migration to a newer version of SQL Server available for commercial use.

Now assuming you’re aware of this situation and considering upgrade/migration to a newer/supported version of SQL Server or searching for help on how to import SQL Server database to SQL Server 2014 or another version, you’ll get to know about the same in this article via different approaches. Also, we’ll shed some light on an advanced SQL database recovery tool that comes handy to tackle issues such as database file corruption, database marked with the suspect stamp, etc. In scenarios like these, the user search goes on for help topics like methods to recover SQL database without backup, tips to recover SQL database from suspect mode, how to recover deleted records in SQL Server, and more.

Note: Make sure that you’ve downloaded the latest, preferred, and supported build of SQL Server (SQL Server 2014) and installed it either on the same system or on a different machine, before you implement any of the methods given below.

Import SQL Server 2008 Database to SQL Server 2014 Manually

To import the SQL Server 2008 Database to SQL Server 2014, opt from any of the native & manual method listed below.

  1. Using Import & Export Wizard

    The data transformation services Import & Export wizard provides the user the ability to migrate complete database or move selective database objects to the destination database.
    You’ll need Microsoft SQL Server Management Studio for implementation of this method, follow the steps below to import the SQL Server database:

    1. Open SQL Server Management Studio on the source server,
    2. Select the database & right-click, select Tasks > Copy Database,
    3. Copy Database windows will pop on-screen,
      Here, select the source & input destination database credentials,
    4. Specify the preferred settings configuration,
    5. Click Next,
      Note: In this step, you can also choose to schedule SQL Server 2008 database to SQL Server 2014 migration for a specific time frame.
    6. Click on the Execute button to start the migration/transfer,
    7. Done.
  2. Using Backup & Restore
  3. You can create the database backup and restore it further using Transact-SQL statements, follow below-given steps:

    1. Archive full database including all the instances,
    2. Specify the target location and copy the backup there,
    3. On the destination server, initiate database restoration by specifying the WITH NORECOVERY option,
    4. Overwrite the existing database using the WITH REPLACE option,
    5. Finish.
  4. Using Generate Scripts Wizard
  5. Another method to import/migrate SQL Server 2008 database to SQL Server 2014 is to generate scripts; steps are as follows:

    1. Open SQL Server Management Studio on the source server,
    2. Select the database and right-click > Tasks > Generate Scripts,
    3. Configure settings for migration as per the preference,
    4. Confirm, script data = true is selected to move data as well,
    5. Click on Next > Next > Finish,
    6. Now, connect to the database server & create a new database in it,
    7. Click on the New Query button on the navigation bar,
    8. Paste script generated by the GSW (Generate Scripts Wizard),
    9. Now, execute the query on the destination database, Done.
  6. Using Attach & Detach
  7. To use, attach & detach, go through the steps given below one after the other:

    1. Detach the source server using sp_detach stored procedure,
    2. Now, copy the MDF, LDF, and NDF files to the destination PC,
    3. Now use the sp_Attach_db stored procedure to attach the database to the target server,
    4. Browse to the location where you’ve saved the copy of database files in step-2, on the new system,
    5. Finish.

Automate SQL Server 2008 Database Import to SQL Server 2014

With the methods listed above, one can successfully migrate from SQL Server 2008 to 2014, but these manual methods aren’t fully secure because of process loops such as mistyped Transact-SQL statement, database file corruption, database file damage when transferring to another system, and more.
Additionally, to start using any of the given manual methods, it is necessary for the user to understand the process & statements used; this sometimes turns hard & confusing for many users and again results in data loss due to file corruption. Here, we’d suggest the users to use a standalone SQL recovery tool.

Kernel for SQL Database Recovery is an advanced tool, made specially to fix all issues related to SQL Server database files. Along with repair & recovery of corrupt or damaged database files, the tool can restore MDF/NDF files to live SQL Server. To simplify the whole process of database transfer/migration, Kernel for SQL Database Recovery automates all backend commands leaving only a few clicks for the end user, as it doesn’t require the user to have any prior technical knowledge in terms of database migration/import.

Go through the steps given below sequentially to import SQL Server Database 2008 to SQL Server 2014 with ease.

  1. Open Kernel for SQL Database Recovery,
  2. Click on Browse to select the database file,
    Select the Standard Recovery Mode and click Recover.
    Select Standard Recovery Mode
    Note: You can select both healthy & corrupt or damaged database files here. In case, if the level of file corruption is high, then select Advanced Scan mode.
  3. Wait for the scan process to complete.
    Scanning process
    Note: If you wish to choose a different database file then, click on the Stop button to immediately halt the Scan process.
  4. Upon successful file scan, the tool’s UI – User-Interface will refresh and load all the data stored inside,
    Checkmark all or select database objects to recover > click on Save button,
    Select database objects to recover
    Note: Click on any object to view the item and its data.
  5. Saving Mode window will appear on-screen,
    Now, to import SQL Server 2008 database to SQL Server 2014, select SQL Server radio button,
    Select the Server Authentication option > input credentials, as shown below,
    Input credentials
    Note: To save the recovered files locally, if the files were corrupt or damaged then, select Batch File option, provide the destination path and click Ok.
  6. Provide the destination path

  7. Wait for the saving process to finish,
    Saving process
    Note: To reselect database objects to reduce overall file size, click on the Stop button and repeat from step-4,
  8. Click Ok.
  9. Finish the process

You’ve successfully migrated the database from SQL Server 2008 to SQL Server 2014 with ease.

Read Also : How to Migrate SQL Database 2008 to SQL 2016?

Wrap

Native methods for database imports eliminate the need of downloading any other software but they are long, requires prior technical knowledge, and confusing for those who are not well experienced with Transact-SQL statements and SQL Server Management Studio. In the same place, Kernel for SQL Database recovery accompanies the user with easy database migration by automating the whole process, and it can assist you in help topics such as recover deleted records in SQL server, recover database file(s) after corruption and more.