Armed Polite Society

Main Forums => The Roundtable => Topic started by: AZRedhawk44 on March 11, 2009, 04:11:04 PM

Title: Toad or Red Gate?
Post by: AZRedhawk44 on March 11, 2009, 04:11:04 PM

SQL Jockeys of APS, tell me your preference.

I need a good utility to dump a model database to a single script for later installation/import at client sites.  I'd prefer to stay away from the tactic of using a backup, since SQL Server 2000/2005/2008 databases are not interchangeable between versions of the DB Server and give "fun" messages when restoring a 2000 database to a 2005 server.

Other tasks that will be useful will be scripted alterations of table/index filegroup assignments and any other potential niftiness I can wring out of it.

Opinions?  Other products not listed?

Title: Re: Toad or Red Gate?
Post by: Nick1911 on March 11, 2009, 04:59:41 PM

In my real job (read: "paying"), I use TOAD to manage oracle.

I had not used it before this gig; I've been working with it for a bit over a year.  It does pretty much everything I want to do with it, as a software engineer.  Pretty speedy, too.

Never used the other one, so I can't compare/contrast.