Azure SQL Database Ignition Compatibility

[knicholas]

Has anyone used or connected their Ignition Project with Azure SQL Database?

I cannot find any information on the compatibility with Azure SQL Database with Ignition 8.1. I wanted to use Azure SQL Database instead of just a VM with MSSQL.

If so, are you happy with the result? What is the server spec and how many tags does your project use?

[josborn]

I have not, but if you search for topics, it looks like it's been done.

Ignition connection to Azure SQL Database

Hi, I’m having trouble connecting to an Azure SQL database from a separate Igniton server. This is how I set it up: Microsoft SQLServer JDBC Driver Connect URL: jdbc:sqlserver://SQL server name.database.windows.net Username: SQL user name databaseName=Existing database in SQL server What should I use as the instanceName? Do I also need to allow port 1433 or 1434 as a firewall outbound rule on the Ignition server? I can connect to the database via SQL management studio on the Ignition ser…

[knicholas]

@josborn, I have successfully connected it to the Azure SQL database.

The steps are pretty easy. You just have to use the JDBC connector from the Azure SQL database and its address. Almost the same steps as using MSSQL/Express.

[ryanjmclaughlin]

Just moved a bunch of our old MSSQL DBs to Azure SQL. Ignition was easy, just change the connection string. I would make sure to update your JDBC driver to the latest. I used the DTU based tiers, its very easy to monitor performance and bump up or down accordingly.