CODEWITHSUNDEEP
visual-studioazureazure-sql-databaseazure-storageazure-table-storage
Manuel F.
Manuel F.

Reputation: 113

From Sql Database to Azure Storage Emulator

I have a Sql database and I have to put it in my Azure Storage Emulator (In Storage > Development > Tables); how can I do it? In Visual Studio I don't find any possibility to import, for example, a .bacpac file.

UPDATE:

I discovered that the database should not be put in there, but then how do I properly simulate Azure storage and my Sql database as well?

Upvotes: 1

Views: 582

Answers (2)

Neil Thompson
Neil Thompson

Reputation: 6425

Just to clarify: Azure Storage (Tables, Blobs, Queues) is completely different from SQL Azure databases.

If you use the latest version of SQL Express it's very very similar to SQL Azure and fine for most development needs.

There isn't a SQL Azure simulator that I know of - but it's really easy to get a FREE 30 day Azure account and I would strongly suggest you do some development and testing against that: SQL Azure has far more connection issues (no connection, handshake problems, lags) than a database that is local to the app, and you need to be prepared for this (investigate Transient Fault Handling strategies).

You can work locally and connect to your SQL Azure instance = a 'real' SQL Azure simulation.

Upvotes: 1

Joseph Idziorek
Joseph Idziorek

Reputation: 5111

When developing locally for Azure SQL Database, please use SQL Server Express - it is the relational database equivalent for Azure Storage Emulator (Azure Blob, Queue, and Table).

Upvotes: 0

Related Questions