Azure SQL to SQL Server Connection-Azure SQL Table Upload
What is Azure SQL?
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business.
With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. SQL Database can be the right choice for a variety of modern cloud applications because it enables you to process both relational data and non-relational structures, such as graphs, JSON, spatial, and XML.
Azure SQL Database is based on the latest stable version of the Microsoft SQL Server database engine. You can use advanced query processing features, such as high-performance in-memory technologies and intelligent query processing. In fact, the newest capabilities of SQL Server are released first to SQL Database, and then to SQL Server itself. You get the newest SQL Server capabilities with no overhead for patching or upgrading, tested across millions of databases.
How to load files to database in Azure SQL cloud?
First, we create the resource. Secondly, we start to create sql database.
Then we click on the database and come to the properties section. Here we copy our service name and server name for SQL login.
Then we enter SQL and paste our service name, user name and password here.
You will get a security screen like the one below. Here you need to come to the Azure SQL section and introduce your IP. After introducing, we log in again.
Then you go back to SQL and click “Sign In” to log into your Azure account. This way you have access to SQL.
After logging into SQL, we right-click on the AdventureWorks database and do the classic installation logic. We upload our file by clicking on the Import data option. In the next section, we encounter the password screen. We enter our Azure information by selecting SQL in the “Destination” part. Then we upload our file by saying next.
After the file is uploaded, we come to Azure SQL and check whether our table is loaded. If it is installed, we open the data by right-clicking. Now tables ready to write queries!
You can find the settings for Azure SQL Database installation on Microsoft’s site:
