topic Re: How to Migrate Database from SQL Server 2008 to 2014? in Data Protection

How to Migrate Database from SQL Server 2008 to 2014?

Andrew321 — Fri, 01 Dec 2017 06:52:12 GMT

I have a large database up to 159 GB. The database of SQL Server 2008 is saved on one machine. I don't have much knowledge about Import/Export wizard nor I have a secondary storage like pen drive which could store this 159 GB data to move database files from one machine to another. Is there any good option that I can use to migrate the database from SQL Server 2008 to 2014?

Re: How to Migrate Database from SQL Server 2008 to 2014?

matte — Fri, 01 Dec 2017 10:37:41 GMT

So, basically you want to upgrade SQL server to a newer version, correct?

i think you should post this question on a micorosft forum for better assistance.

As far as i know you can perform an in-place upgrade to SQL Server 2014 using the graphical Installation or you can upgrade using a configuration file.

If instead you want to install SQL on another machine and mugrate the database there i think you have to depoly the new machine, isntall SQL 2014 and follow the Micorosft best practices for the database migration.

Re: How to Migrate Database from SQL Server 2008 to 2014?

Andrew321 — Sat, 02 Dec 2017 06:35:47 GMT

Thanks for your valuable response, I was searching a lot for the solution and every time I stuck in backup and restore which was not possible in my scenario. I got the recommendation of SysTools SQL Server Database Migration from here https://stackoverflow.com/questions/18866321/how-to-copy-sql-server-2008-r2-database-from-one-machine-to-another who helped me in migrating SQL Server database from 2008 to 2014.

Re: How to Migrate Database from SQL Server 2008 to 2014?

Uliana — Wed, 13 Dec 2023 16:47:00 GMT

If you need to transfer your database to another machine with a different version of SQL Server, you can try software for automated database migration Ispirer Toolkit.