Larry Brister
asked on
SQL Server Backup to previous version
Is it possible to make a SQL Server 2014 instance of a database backup that can be restored to a 2012 Instance?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is Transfer Wizard better than SQL Data Examiner?
I don't know. I don't recall ever using SQL Data Examiner myself.
ASKER
Then can I create a copy of the database locally that is the previous version? ANd make a backup of that?
No. A SQL 2014 db cannot be directly transferred to a SQL 2012 instance except using some type of conversion.
ASKER
OK
Reviewing all of this and will award points in the next couple of hours
Reviewing all of this and will award points in the next couple of hours
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for late response. Was out of country
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-compatibility-level