azure-database | Azure Database ( Table Storage | Azure library

I'm trying to export our production Azure SQL database to local for testing purposes. I've made a copy of the database but get the following error when trying to Export.

One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501: Error validating element [dss]: Schema: [dss] has an unresolved reference to object [##MS_SyncAccount##]. Error SQL71501: Error validating element [TaskHosting]: Schema: [TaskHosting] has an unresolved reference to object [##MS_SyncAccount##].

I've found this article explaining how to get around this issue:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/exporting-a-database-that-is-was-used-as-sql-data-sync-metadata/ba-p/369062.

My question is, will running the script below (from the article) on the copied database affect only the copy's data sync meta data, or is there a risk that it will affect our production database or server in any way?

Script: https://raw.githubusercontent.com/vitomaz-msft/DataSyncMetadataCleanup/master/Data%20Sync%20complete%20cleanup.sql

Many thanks

I have a MySQL database on Azure, using the Azure managed database service, and two Ubuntu 20.04 VMs (running PHP applications) in the same VNET. I can connect to the database from both PHP, and from a remote GUI client (SequelPro), so I'm confident the firewall is configured correctly and I'm using the right details.

However, when I try to connect using the mysql CLI client on either of the VMs, it just hangs with no output. I've tried on both VMs, I get the same behaviour.

The command I'm using is:

mysql -u "username@hostname" -p -h "ip_address" -P 3306 database_name -e "SHOW TABLES"

It prompts for the password, so I enter it... and then nothing. On top the mysql process is consuming 100% of CPU.

I can telnet port 3306 on the IP address, I get the usual gibberish asking for mysql_native_password.

If I change the hostname part of the username@hostname to an invalid hostname, then it says "The servername cannot be found". Whereas if I enter an invalid username (or an invalid password) then it hangs just the same. So I'm guessing this has something to do with the gateway part of Azure managed database service that's trying to resolve that name. Everything was working normally up until a few days ago.

There's nothing in any of the logs, and no output on the screen, so I can't work out where to begin trying to fix this.

We have a curious issue with our Azure SQL database with AAD authentication.

We have created a role (dbt_user) with all permissions, and excluded some schemas:

I'm using the library Devart.Data.PostgreSql (https://www.nuget.org/packages/Devart.Data.PostgreSql/) to interact with PostgreSQL from a C# application, but I run into problems when I try to connect to a PostgreSQL instance hosted in Azure that enforces TLS 1.2. From what I understand there is a problem with ciphers not being able to match during the handshake as I end up with this exception:

I know Azure does its own backups in the cloud. However, due to company policy I need to generate a local backup copy of the database and be date-time stamped.

I've read this, and it has allowed me to create a .bacpac file and import it into our on-prem SQL server (2019). What I want is a way to save the bacpac file on a network folder, on a regular basis.

UPDATE - no I don't have to, store the bacpac file in an on-prem database. I only mentioned it to say, yes I can do this extra step. What I really want is to simply save the bacpac file, date-stamped in the filename, and in a network folder on-prem.

I am learning azure from Microsoft learn using this link. Does anyone know the basic difference between "Azure Database for MySQL" and "Azure SQL Database"? Both seem very similar.

As I am a beginner, can anyone explain the difference in an easy way?

I have connected my NestJS project with a CosmosDB database using the @nestjs/azure-database package. I have successfully created a first item in my database, but whenever I try to add another one (create function), it gives me following error:

Using Matlab and its database toolbox, I need to connect to an Azure server using Microsoft SQL, using the Azure ActiveDirectoryPassword authentication mode. However Azure active directory connections are not natively supported, and some extra steps are required. Matlab uses Java, so it is via Java drivers and libraries that I need to set up the connection to my database. In the latest iteration of me trying to solve this issue, I encounter the following connection error: JDBC Driver Error: Failed to load ADAL4J Java library for performing ActiveDirectoryPassword authentication.

Via this somewhat related question: https://forum.knime.com/t/connect-to-azure-database/20585, I was referred to the Microsoft page on how to setup the connection: https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver15. The instructions on this page tell me On the client machine (on which, you want to run the example), download the azure-activedirectory-library-for-java library and its dependencies, and include them in the Java build path.

Following up, the Microsoft webpage forwards me to the Github page, to install the ADAL libraries.

Now, here the confusion continues, because I have zero clue what to do next. I don't know any Java, and I am not even using Java directly as everything runs via Matlab functionality that uses Java in the background (The only thing I do is use a connection URL to setup the connection to the database). The help files on the ADAL/MSAL Github are unclear for a novice like me and do not seem to be focused towards helping simple Windows users setup all the libraries. So I am looking for help to get everything running.

What is currently running?

• Operating system: Windows 10 64-bit on server infrastructure
• Java: on the pc in question AdoptOpenJDK Java is installed, version jdk-8.0.265.01-hotspot
• Matlab: I have two setups that I need to get working, Matlab 2017a and Matlab 2020a. Matlab 2017a only supports up to Java 7 and Matlab 2020a works with Java 8. It also seems that (some parts of) Java are shipped with Matlab. Using the version -java command in Matlab, I obtain the following information:
  • Matlab 2017a: Java 1.7.0_60-b19 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
  • Matlab 2020a: Java 1.8.0_202-b08 with Oracle Corporation Java HotSpot(TM) 64-Bit Server VM mixed mode
• JDBC-driver: via Microsoft JDBC I downloaded two versions of JDBC drivers: Microsoft JDBC DRIVER 6.4 for SQL Server and Microsoft JDBC DRIVER 8.4 for SQL Server. Matlab 2017a will use driver 6.4 (because it uses Java 7) and Matlab 2020a will use driver 8.4.

My questions:

1. Do I use ADAL or MSAL?
2. How do I get the library I need included in Java such that Matlab can use it?

What I tried:

• I downloaded the .jar file for MSAL and included it in the javaclasspath of Matlab, hoping that that would include the MSAL-library in Matlab-Java. Unfortunately that doesn't work.
• I looked at the ADAL github, trying to figure out how to get that integrated into Java. However I do not understand how to make that happen.

Any help would be greatly appreciated, thank you!

I am new to SQL Server authentication methodologies. I am trying to learn to create a read-only user who can access Azure SQL data from Power BI. I have followed the steps and created a login and user as suggested in this post. I am able to login to the database using 'login' and password as suggested here.

My concern is, as I created the user and assigned him the role of the 'db_datareader'; how does this guarantee that I can't modify something in another database(as there can be multiple user associated with login with a different role)? Is there any way I can directly login to the database using username?