The tricky part about transferring objects is that DTS etc. does not take dependency order into account meaning that you'll have to do some manual tweaking for anything other than...

You might also want to look at the Packager Plus product from Innovartis

(http://www.innovartis.co.uk). It can package your data and schema and dynamically update the target database at...

Relying on the Upgrade Advisor may leave you with a broken database even if everything appears to check out.

To see why please see our page on the subject at

Another tool you may want to consider is DB Ghost from Innovartis (http://www.dbghost.com) - as well as schema/data compare and synchronization it also lets you store your "source database"...

The best way to move your database from SQL 2000 to 2005 is to script it out (schema and data) and then rebuild it from scripts in SQL 2005. ...

No pricing means that they want to actively sell it to me and I don't want to be hassled like that as I don't have the time. I'm intelligent...

Great review Jeremy - thanks!

I would disagree on one point though - using DB Ghost against the production database.  I would recommend this for the following reasons:

1. When DB Ghost is...

Storing the drop/create scripts for stored procedures and, indeed, every other type of database object in a source control/configuration management system should be standard practice for any development shop.  You do it without...

Excellent article as usual Grant!

I think the best part is the advice to practice the recovery steps when you're not under the cosh.  In fact I would recommend that all...

Hi,

If you want to compare and synchronise schema (structure/metadata) and/or data then I recommend usign DB Ghost (http://www.dbghost.com). Not only can it give you a delta script of the...

Hi Christiaan,

Having ALL of your SQL objects, not just stored procedures, triggers and UDFs, under source control is the ultimate solution.  This way every single object gets the benefit of...

I agree 100% - I buy Dell laptops every time because of the fantastic support.  The one time I had a hardware failure a guy turned up within 2 hours...

When you use the /3gb switch it restricts the Windows kernel address space to only 1GB and this is why you can experience more performance problems with this option set.

The...

As previously mentioned here is the obligatory DB Ghost plug

Diff tools are great, don't get me wrong, and they offer a great deal...

Although I have never used Litespeed 2005 (I used the previous version) and, by all accounts, it is an excellent product I would have respected your review more if you...