How to preserve identity seed value across import/export?


  • Hello,

    I have a SQL Server database which inserts some base data then reseeds the identity column to 10000. The Data Migration Assistant correctly migrates it to Azure. However, when I export and import my database, the seed value is always 1. Not only would I like to preserve my seed values in all tables so the application functions as expected but I am also nervous that other, less obvious changes are being introduced. Is this expected behavior? How can I export the exact state of my Azure SQL database so that I get an identical one on import?

    Thank you!

    13 iunie 2018 12:44

Toate mesajele