This is when you need to focus on automation tools like Windows PowerShell. To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages.

SQL Advisor. Query SQL Server with PowerShell. Get the right information on your SQL Servers via the Get-Service cmdlet. By Joshua Jones; 03/10/2011; Last time, I discussed how to get PowerShell and ...

There are lots of ways to create MSSQL databases via PowerShell. We could invoke a T-SQL query using the CREATE DATABASE term, we could write some code to use the [Create() method with SMO] or, if ...