Here's what I do.

Make a copy of the target database.

Perform comparison and synchronization and produce a delta script using the copy of the target database.

I know the delta script works...

maybe it isn't worth dropping the indexes any more and instead do the data load and defrag the indexes after the load. The data load may actually take less than...

Hello Phil Cart,

>I'm sure that everyone you talk to knows how "GREAT" your program is, but this doesn't mean that other products...

that's the problem (dependencies) I've always encountered. What I do is build the database object by object in a recursive loop until I get no errors (even sysdepends errors) and...

Let me know if it works, I've found this to be unreliable and I think I have a better way.

sounds like high mantenance and prone to error due to the need for human intervention IE: strict rules - very unlike DB Ghost. But good luck to you.

how do you handle dependancies?

for databases? I don't think so.

Please look at DB Ghost (http://www.dbghost.com) it has build, comparison and synchronization abilities directly from your source control which is - if I'm not mistaken - exactly what you...

without using system tables as the system tables will not be available in SQLServer 2005...

use Northwind

GO

set nocount on

declare @table_owner sysname, @table_name sysname, @column_or_index_name sysname

declare @result varchar(25),@param nvarchar(261)

--set the variables

select

 @table_owner =...

try modifying your login time out:

Using enterprise manager: Tools>Options>Advanced Tab>Login timeout (default is 4 seconds)

regards,

Mark Baekdal

http://www.dbghost.com

http://www.innovartis.co.uk

+44 (0)208...

I think all of the above products have their place however they do not cover change management. Here's an article on the subject which has been extensively researched. http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf

The...

maybe I can learn something and my apologies if I sounded condescending

regards,

Mark Baekdal

http://www.dbghost.com

http://www.innovartis.co.uk

+44 (0)208 241 1762

Build, Comparison...

there's a saying that goes "why code when you can download"

Re-inventing the wheel is more costly than buying a well tested product that solves the problem.

But seriously, I find my...

to me comparing databases is usually a sign that you don't know what is in the database and therefore your change management system is faulty or non-existant. That being said...