question

AmarAgnihotri-6676 avatar image
0 Votes"
AmarAgnihotri-6676 asked AnuragSharma-MSFT commented

Sql Endpoint Setup with ownbackup

Hi Guys!
I have to create a SQL Endpoint setup with own backup but i am struggling to find all required pieces from my SQL. Can anybody help me regarding that by providing some useful links which could show the step by step process of setting up .





Thanks in advance

azure-database-mysql
· 10
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AmarAgnihotri-6676, welcome to Microsoft Q&A forum.

From the problem statement we understand that you want to migrate on-premise MySQL backup to Azure Database for MySQL. Below are couple of links that will guide you step by step on this process:

  1. Migrate your MySQL database to Azure Database for MySQL using dump and restore

  2. Tutorial: Migrate MySQL to Azure Database for MySQL offline using DMS

  3. Migrate MySQL on-premises to Azure Database for MySQL: Migration Methods

Please let us know if this is what you are looking for or else we can discuss further on the same.




0 Votes 0 ·

Hi @AnuragSharma-MSFT ! Thanks for the reply. Actually we are using own backup tool to create backup of Salesforce data everyday when there is any change in the objects. I want to import that backup data into azure by creating my sql endpoint. Hope you understand my problem. Please suggest regarding this.


Thanks

0 Votes 0 ·

Hi @AmarAgnihotri-6676, thanks for responding back.

If we go through the first article that was mentioned above it talks about how can we create an empty Azure MySQL DB and load the data from backup/dump created.

When you say you want to create MySQL endpoints we assume you want to create a Azure MySQL Database, please let us know if this is not correct and we can discuss further on the same.

0 Votes 0 ·

Hi @AnuragSharma-MSFT !
I am facing this error while connecting from MySQl Workbench. Can you please look into this.

134321-mysql-workbench-error.png


0 Votes 0 ·
Show more comments
AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered AmarAgnihotri-6676 commented

<Writing this as answer as it was crossing 1600 characters limit>

Firstly I would like to thank you for all the positive words and glad that you are choosing Azure in your company. We actually try to provide solution to all your queries on Microsoft Q&A forum. Now Azure offers a lot of services and I would know few but not all. Posting your queries here would make appropriate group of people to look and respond to them. Also more and more users can see and would be benefitted with the solution. It does not matter if query is minor or major, please feel free to post it here anytime.

Coming to the issue, SSMS and MySQL Workbench are 2 tools for 2 different kind of databases i.e. SQL Server and MySQL respectively. In both of these, we have 2 ways to create databases. One is on-premise which is local to our system/server and other is on Cloud (Azure). To use on-premise we need to have a server installed on our local system. But in case of Azure we just need to connect to Azure Database and we can start working directly by creating tables and all.

We can install SQL Server from below link and then you can start creating database
https://www.microsoft.com/en-in/sql-server/sql-server-downloads

For salesforce again we need to choose where we need to load the backup into, in Azure SQL or Azure MySQL. Below is one article to start with where we use Azure Data Factory to read data from Salesforce.

Copy data from and to Salesforce using Azure Data Factory or Azure Synapse Analytics

However, I would first recommend you to get comfortable with Azure Databases by connecting them through specific tools. We can keep on discussing here until you have a proper solution to all your queries. We can go step by step here. Please try it once and let me know your next query and I would be delighted to provide solution of it.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @AnuragSharma-MSFT

0 Votes 0 ·
AmarAgnihotri-6676 avatar image
0 Votes"
AmarAgnihotri-6676 answered AnuragSharma-MSFT commented

Hey @AnuragSharma-MSFT ,
I read the article you provided. What i understand is that if want to salesforce data to azure for Analytics purpose then we don't need to have Azure SQl or MYsql database rather we can copy data from salesforce directly to Azure data factory. Am i right? Correct me if i am wrong.

· 21
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for replying back. SO through ADF we can read and write data from sources to destinations. We can read from one source and write to another destination. As an example if we have our source as salesforce from where we read the data and then destination is azure sql database, then we can utilize ADF to do that. It is basically kind of ETL tool like SSIS.

0 Votes 0 ·

Hi @AnuragSharma-MSFT

Thanks for the reply and support. We take backup of Salesforce data using OwnBackup tool everyday. This tool export a backup. The options that it shows in the backup export is shown in the snap attached . I exported it as Mysql. Now i want to import that .sql file to Azure database. My concern is that i want it to store it to SQl server database for azure because i believe that sql server is better than MySQL. So please suggest me which database would be best to import the backup and please suggest me a link which could show the step by step process to import this backup file to azure.

Hope you understand my concern .

135306-ob1.png135264-ob2.png135265-ob3.png135266-ob4.png


0 Votes 0 ·
ob1.png (162.5 KiB)
ob2.png (233.3 KiB)
ob3.png (232.1 KiB)
ob4.png (237.2 KiB)

Thanks for the detailed reply, really appreciate. So what I understand from your query is you have MySQL backup that has to be migrated to Azure SQL database. You can refer to below article that has step by step migration using SQL Server Migration Assistant for MySQL

Migration guide: MySQL to Azure SQL Database

Could you please once check it and see if this meets your requirements and then we can discuss further if we have any query related to implementation?

0 Votes 0 ·
Show more comments