Thursday, August 3, 2023

SQL Server - database migration to lower version of Microsoft SQL Server (backup version is incompatible with this server)

Restore Failed: The database was backed up on a server running version xx.xx.xxxx. That version is incompatible with this server, which is running version xx.xx.xxxx.


  1. Go to the source server with Microsoft SQL Management Studio
  2. Select database to be exported and choose: Export Data-Tier Application 
  3. Save file to local disc
  4. Go to destination server, choose databases and Import Data-Tier Application

     
  5. Import previously created .bacpac file 

  6. Set database name and location and press finish 












No comments:

Post a Comment

Problem with database open ORA-19804, ORA-19809, ORA-03113

1. Try to login to database with SYS AS SYSDBA user. If the instance is idle, run the startup command. 2. If ORA-03113 occured, check the la...