Automate creation of 'n' number of Data Warehouses in SQL Server
Posted on 2008-10-15
I am currently creating a generic 'data warehouse' for multiple clients. Generic in the sense that each client database uses an identical structre.
I am trying to find a way of automating this process so that if I update a view/procedure in a 'master' copy I can run a procedure to re-create all the client copys.
Each client has:
views to extract data from linked server
stored procedures to feed the reports and generate tables from views
I was think along the lines of having a table in the 'master' copy with a list of clients that could be used as parameters to create databases, logins, users, linked servers ,views etc for each client.
Is this possible?