Sql Endpoint Setup with ownbackup

Amar Agnihotri 921 Reputation points
2021-09-17T07:48:41.48+00:00

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 for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
747 questions
{count} votes

Accepted answer
  1. Anurag Sharma 17,581 Reputation points
    2021-09-23T07:15:03.123+00:00

    <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 additional answer

Sort by: Most helpful
  1. Amar Agnihotri 921 Reputation points
    2021-09-23T10:41:55.947+00:00

    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.