vendredi 25 décembre 2015

Restoring SQL 2014 database in SQL 2005

I am trying to restore a SQL 2014 database in SQL 2005. I am doing by generating the complete script (with schema and data) from SQL 2014.

I get an error saying

'INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.'

and

'Cannot insert explicit value for identity column in table 'T_GASAdminNote' when IDENTITY_INSERT is set to OFF.'

I have searched for solution but have not been able to rectify the problem. I have tried the solution given in this link, but it didnt help me.

Can anyone suggest me some solutions for restoring the database.

Aucun commentaire:

Enregistrer un commentaire