Applying Your Scripts across Multiple SQL Server Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Dinesh Asanka » Applying Your Scripts across Multiple SQL...

Applying Your Scripts across Multiple SQL Server Databases

Rate Topic

Display Mode

Topic Options

Author

Message

Dinesh Asanka

Posted Thursday, March 20, 2008 12:01 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912, Visits: 198

Comments posted to this topic are about the item Applying Your Scripts across Multiple SQL Server Databases

My Blog: http://dineshasanka.spaces.live.com/

Post #472064

back_of_the_fleet

Posted Thursday, March 20, 2008 3:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:58 AM
Points: 184, Visits: 360

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.

Inflatable sailors never die, they gently deflate over time.

Post #472103

Anipaul

Posted Thursday, March 20, 2008 3:29 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 4,787, Visits: 1,335

The tool seems cool. But I should not comment on these in positive or negative unless and until using it. As the tool is new we will know the advantages and disadvantages of it when it will be extensively used in production.

Thanks to the author for explaining it well. :)

Regards

Post #472108

back_of_the_fleet

Posted Thursday, March 20, 2008 3:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:58 AM
Points: 184, Visits: 360

I concur with Anirban. We have to use it a lot more in production to identify any pitfalls. However, I am using the product in my production environments and so far it does what it says on the tin.

Inflatable sailors never die, they gently deflate over time.

Post #472110

brad.buntin

Posted Thursday, September 11, 2008 1:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 06, 2009 2:13 PM
Points: 1, Visits: 2

I personally prefer QueryBlaster (www.QueryBlaster.com). I have been using it on my production servers for a few months now and I love it. No more skipped over databases and I'm finished in a fraction of the time!

Post #567507

« Prev Topic | Next Topic »

Permissions