• I am responsible for 16 databases on a single server - each database is the same 'shape' (ie. tables/views/stored procedures) etc., but contains data from disparate sources. When applying database changes I had a tick list to make sure the same changes were applied to each database, and in some cases there were multiple scripts to be applied. I'd sit in front of Management Studio waiting for a script to complete (which, when data changes were being made, could take some time over millions of rows). Then I'd move on to the next database.

    Then I bought Multi Script which now manages the whole lot for me. I've binned my tick lists.


    John Rogerson
    BI Technical Lead
    Clear Channel International