I am looking at the possibility of deployments using ansible roles. The issue that I find is that ansible works at the host level within the defined inventory. SQL server on the other hand works differently, its a one to many relationship. You can have multiple SQL instances on a host.
My scenario is wanting to deploy the below script across 500 SQL instances. The 500 SQL instances equated to 350 ansible hosts.
Below is the deployment script.
use mydb
GO
if object_id(‘persons’) is not null
drop table dbo.persons
GO
create table persons
(
id int identity (1,1),
name varchar(200)
)