JimiJ13
asked on
Backup SQL 2014 to 2012
Dear Experts,
Is their any workaround to backup SQL2014 and restore to SQL2012? Is there a need of a special utility like Red-Gate or what?
How?
Thanks.
Is their any workaround to backup SQL2014 and restore to SQL2012? Is there a need of a special utility like Red-Gate or what?
How?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unfortunately, none has acceptable suggestion to my issue. My engineer manually scripted the db with compatibility setting to MS SQL 2012 and completed with the data using other 3rd party tools upon re-creation.
Thanks for trying to help.
Thanks for trying to help.
ASKER
Thanks for your suggestion. However, we need the whole structure restored to MS SQL 2012 not just data.
Any idea?