azure-sql-database

How do I copy SQL Azure database to my local development server?

by

Does anyone know how I can copy a SQL Azure database to my development machine? I’d like to stop paying to have a development database in the cloud, but it’s the best way to get production data. I copy my production database to a new development database but I’d like to have that same database … Read more

Reset identity seed after deleting records in SQL Server

by

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have a primary key and identity defined. But since I have to delete some records from … Read more