Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: Azure SQL Database Extensions Type for Import Database #899

Closed
mshorrosh opened this issue Feb 27, 2018 · 5 comments
Closed
Labels
new-resource service/mssql Microsoft SQL Server

Comments

@mshorrosh
Copy link

It would be nice if there was a way to preform database imports for bacpac files with Terraform, similar to the ARM type available for this:

Example:
{
"name": "importDB",
"type": "Microsoft.Sql/servers/databases/extensions",
"apiVersion": "2015-03-01-preview",
"properties": {
"storageKeyType": "StorageAccessKey",
"storageKey": "",
"storageUri": "",
"administratorLogin": "",
"administratorLoginPassword": "",
"operationMode": "Import"
}
}

Thanks,
Matt Shorrosh

@tombuildsstuff
Copy link
Contributor

hey @mshorrosh

Thanks for opening this issue

I'm unfamiliar with SQL Azure - out of interest, is this different from a PointInTimeRestore which is available using the azurerm_sql_database resource at the moment? Here's an example of how to use that from our acceptance tests.

Thanks!

@mshorrosh
Copy link
Author

Hey @tombuildsstuff

Yes - this is a different feature, point in time restore is different then this Database import feature which is used to import an initial database schema in the to the DB using .BACPAC files.

Here is the azure docs describing each one of those:

https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-import

Thanks,
Matt

@hbuckle
Copy link
Contributor

hbuckle commented Mar 13, 2018

I just raised #972 to support this

@tombuildsstuff tombuildsstuff removed their assignment May 23, 2018
@WodansSon
Copy link
Collaborator

Closing issue as #972 was merged on Jun 19, 2018.

@ghost
Copy link

ghost commented Mar 30, 2020

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 hashibot-feedback@hashicorp.com. Thanks!

@ghost ghost locked and limited conversation to collaborators Mar 30, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
new-resource service/mssql Microsoft SQL Server
Projects
None yet
Development

No branches or pull requests

4 participants