Question: I would like to export all the data from a database to a new one with SQL Server Manager studio.

I used import and export assistant (taks -> export data) but after the import when I try to save new data

I have insertion error due to identity column error when I try to insert data:

> 
> com.microsoft.sqlserver.jdbc.SQLServerException: Unable to insert null value in column 'id'
> 
> 
> 

Although I specified to keep identity insert before the export.

I would like to export data in a new database with all the Identities column constraints.

Answer: 
If you want to move all data completely from a database. Task->Export is one Option(since the issue which you face is not clear) you can try other option to take backup(.bak file) and restore it to the new database.

[![enter image description here](https://i.stack.imgur.com/BxmSR.png)](https://i.stack.imgur.com/BxmSR.png)
Thank you for your help, the problem wasn't clear.

I actually needed to export an azure database to a SQL server database.

I used another export process : microsoft.github.io/AzureTipsAndTricks/blog/tip140.html and now the exported local database is working