The Googles are failing for my specific concern. Has anyone moved a database (DBaaS) and the associated parent resource which is part of a SQL Data Sync Group to a new resource group within Azure? I've found that moving the database is supposed to be transparent to applications using it, but can't find specifics on whether the move will also be transparent to the Data Sync. Permissions between the resource groups are identical and the resource groups are within the same tenant and subscription.
Move Azure SQLDB using SQL Data Sync to new resource group
164 Views Asked by IsThisThingOn At
1
There are 1 best solutions below
Related Questions in AZURE
- How to update to the latest external Git in Azure Web App?
- I need an azure product that executes my intensive ffmpeg command then dies, and i only get charged for the delta. Any Tips?
- Inject AsyncCollector into a service
- mutual tls authentication between app service and function app
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Application settings for production deployment slot in Azure App Services
- Encountered an error (ServiceUnavailable) from host runtime on Azure Function App
- Implementing Incremental consent when using both application and delegated permissions
- Invalid format for email address in WordPress on Azure app service
- Producer Batching Service Bus Vs Kafka
- Integrating Angular External IP with ClusterIP of .NET microservices on AKS
- Difficulty creating a data pipeline with Fabric Datafactory using REST
- Azure Batch for Excel VBA
- How to authenticate only Local and Guest users in Azure AD B2C and add custom claims in token?
- Azure Scale Sets and Parallel Jobs
Related Questions in AZURE-SQL-DATABASE
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- Tools for fast aggregation
- Hoiw can i remove all ip addresses from Azure SQL Server Firewall Rules , but still login via SSMS?
- Small percentage of parameters cause very slow queries
- Azure Functions v4 in Private vNet Cannot Connect to Azure Sql
- Does bcp utility support Token based Authentication? If yes, I would like to know the process and which version of bcp to be used
- "Error: Could Not create constraint or index. see previous errors" with nest js and AzureSql
- Recreating an existing edmx in Visual Studio Code for Azure Function
- How to use parameter in Azure sql_input with LIKE SQL command
- How to Process a CSV File from Power Apps/Automate into SQL Server
- Unable to connect to Azure SQL from Azure Data Factory
- Table gets promoted with no data to Prod for Azure SQL database through Azure DevOps
- System Assigned identity failed to connect to SQL Server database
- Optimal approach in accessing datalake container with multiple teams?
- Azure SQL support for Delta tables
Related Questions in AZURE-RESOURCE-GROUP
- Why is "Export Template" button not clickable
- How to get the id of a another resource group in bicep?
- Resource Groups can't be deleted due to Permission issues
- How to list vms by specific Azure resource group
- Azure- Getting (AuthorizationFailed) even with owner role assigned to my account
- Error deploying Azure Synapse on private network with Terraform
- Managing Locks on RG, auto remove locks
- Azure API call not getting logged
- Can't create a new Azure Data Factory ADF with Contributor role
- Azure Resource Graph Query to retrieve all resources of applications using resource groups based on application ID
- Get all Azure resource groups within the specific Azure management group like "ABC"
- What are the supported filter operations on Azure Resource Group list
- Does making an Azure key vault private still allow access to other resources in the same resource group?
- Add a role to an application to a resource group via PowerShell script
- Azure Resource Graph Explorer :: list all resourceGroup with subscriptionName
Related Questions in AZURE-DATA-SYNC
- Table refresh from Azure SQL database to on-premise SQL Server database
- Sync specific data in SQL Data Sync for Azure?
- Eager loading support for Microsoft.Datasync.Client when querying remote table
- Create a user for use with Azure Sync
- azure data sync for temporal table
- How to reuse lambda expression on entities with different property names in EF Core with MS Data Sync?
- How to sync data between from a SQL DB in Azure SQL Server to another SQL DB in a different Azure SQL Server
- Azure SQL Data Sync No Response
- Copy data between tables considering foreign key relationship
- Microsoft.Datasync.Client SSL error with Xamarin Forms
- Azure data sync is in processing state, how do I know how long it will take to complete?
- Import/Export Data from SQL (Azure Virtual Machine) to Azure SQL
- Azure SQL DataSync ##MS_SyncAccount## missing
- Use Azure SQL Data Sync on a Georeplicated Database
- Azure SQL: How to Merge Multiple Db's into a Single Managing Db, while Syncing Bidirectionally any future changes
Related Questions in SQLDB
- Debezium SQL DB connector on AKS - InconsistentGroupProtocolException
- Login failed for user token-identified principal. Token is expired
- Mock Sql DB connection in Nodejs Unit test cases
- ImportError: No module named flask_mysqldb ("from flask_mysqldb import MySQL")
- How to import office 365 usage analytics data to SQL DB using azure data factory
- Column value of one table should be column headings when query is executed
- Stop inserting after reach the limit in PHP and SQL
- what is the easiest way to build forms to import to db
- How to Converting string 'Tue, 07 Dec 2021 04:35:05 GMT' to smalldatetime (yyyy-mm-dd hh:mm:ss) in sql server
- Is there any Option to execute below SQL query's using PowerShell?
- Create Login in Azure Sql db with EXTERNAL DATA SOURCE or any other way
- Use the same DB transaction in different DAOs
- Increase data insert performance
- Inserting Data to Sql Db from Cosmos Db
- External Org Access best approach on Azure AD
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Looks like I've answered my own question so posting here to help others. With the help of my Azure Admin, we created a test SQLDB (with corresponding new DB server) in the same Resource Group as the DB I need to move. I then populated the new DB with test data and setup the Data Sync to a local DB on the same local instance. The initial sync tested fine. We then moved the new test server and DB (have to move both) over to the new resource group, again within the same subscription/tenant. Once completed (after about 5 minutes) we were able to see that while the application relying on the DB did in fact still work fine as expected, and the Data Sync Group showed up, the Data Sync Agent was a no-show. Trying to do a manual sync from the Sync Group did result in an error. So it appears moving DBs across resource groups will break the SQL Data Sync and to fix you'll need to rebuild the sync from scratch. I haven't gone through all those steps on the test DB, but will update this answer if additional issues arise after the actual production move tomorrow night.
Next night: Turns out the actual move was a non-issue. The database didn't show up immediately, even after logging out and back in, but the application never went down and after 5-10 minutes and navigating to Home, then SQL Databases within the portal, voila, the database showed up in the correct resource group AND both the Sync Group and Sync Agent also showed up after selecting "Sync to other databases". Not sure if it was timing or navigating to Home first. Regardless, a manual sync worked as expected. So not sure why our test case didn't work, but it would appear moving a SQLDB to a new resource group within the same tenant and subscription has a good chance of retaining its Data Sync to a local instance. As always though, your mileage may vary.