I have my database in MS SQL 2014. I need to migrate the data from this server to MS SQL 2012 server.I have database size of about 10 GB. I have tried Backup/Restore, Attach/Detach, export/import and creating script but did not work for me because of size and limited user right.None of the solutions worked from
SQL Server database backup restore on lower version
Asked
Active
Viewed 67 times
0
Community
- 1
- 1
pariwartan
- 21
- 3
-
Well - first thing to solve is limited user rights. If you don't have access - you need it or somebody with access should do it. – Allan S. Hansen Apr 13 '16 at 13:57
-
@AllanS.Hansen I have access otherwise I cannot use backup/restore. – pariwartan Apr 13 '16 at 13:59
-
Downgrading a database isn't supported. This isn't data *migration* – Panagiotis Kanavos Apr 13 '16 at 14:00
-
You can script the DDL and then use the import export wizard for the data. – Sean Pearce Apr 13 '16 at 14:02