![]() ![]() Go into SQL Servers, and Add/Select the SQL server you wish to import the database too.Open up and log in with your credentials, on the tenant where your destination SQL server is.Select the Storage account and then blob container.Sign in with your destination tenant credentials.Once you have a blob storage on your destination tenant, download and open Microsoft Azure Storage Explorer If there isn’t one, follow my previous steps in this blog about creating an Azure Blob Storage. Right click on that database and choose from the drop down context menu All Tasks Import Data 4. Create a new database named: AdventureWorksDWAZ2008R2. Uploading export file to new tenant storage.īefore you can upload your export file to your new tenant, first you will need to ensure you have a storage account to upload to. In SQL Server Management Studio, connect to your local SQL Server (this could be SQL Server Express Edition 2008 R2). As I’ve just created it for this purpose the only file within here is my export file. This container blade shows you all the files within this container.Under the container selector you should find the container you created when exporting SQL data.In select your Storage account where you exported SQL to.(Mine took 15 mins before complete) Please see Viewing the Import/Export history later in this blog post for job status.Īfter the SQL export has completed, you will need to download the blob file so that you can then upload it to your destination tenant. Here you have to wait until the job has run, this can take some time. Once you have clicked OK, your request to export the database is sent Azure, and is put into some sort of Microsoft Azure queue behind the scenes. Azure data studio export password#Password: Provide the password for the Server Admin.Server admin login: Provide the Server Admin Username.Containers: Add a container name, and give it private access type, then select it.Storage: Select the storage account you created earlier. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |