0

I have database that runs on SQL Server 2012. Now I need to move this database to new PC and run it on SQL Server 2014.

What is the best way to do it? I far as I understood it is not possible to backup in 2012 and restore to SQL Server 2014.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
vico
  • 17,051
  • 45
  • 159
  • 315

1 Answers1

1

Yes, you can restore a SQL Server 2012 backup into a SQL Server 2014 instance. See here.

Please note, you cannot go the other way - you cannot restore a SQL Server 2014 backup into a SQL Server 2012 instance. See here.

Community
  • 1
  • 1
Donal
  • 31,121
  • 10
  • 63
  • 72