« previous next »
Pages: [1]

Author Topic: Toad or Red Gate?  (Read 1344 times)

AZRedhawk44

  • friends
  • Senior Member
  • ***
  • Posts: 13,982
Toad or Red Gate?
« 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?
Report to moderator   Logged
"But whether the Constitution really be one thing, or another, this much is certain - that it has either authorized such a government as we have had, or has been powerless to prevent it. In either case, it is unfit to exist."
--Lysander Spooner

I reject your authoritah!

Nick1911

  • Administrator
  • Senior Member
  • *****
  • Posts: 8,492
Re: Toad or Red Gate?
« Reply #1 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.
Report to moderator   Logged
Pages: [1]
« previous next »