Link to home
Start Free TrialLog in
Avatar of JimiJ13
JimiJ13Flag for Philippines

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.
SOLUTION
Avatar of Brian Pringle
Brian Pringle
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JimiJ13

ASKER

Hi btpringle,

Thanks for your suggestion. However, we need the whole structure restored to MS SQL 2012 not just  data.

Any idea?
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JimiJ13

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.