You can see in the TendersDB_results14.txt that the exception I get says that the package cannot create the TransactionsFullView because the Transactions table does not exist.

FailedOperationException       
X 1/2/2008 2:53:52 μμ ->   Create failed for View 'dbo.TransactionsFullView'.        
X 1/2/2008 2:53:52 μμ -> ExecutionFailureException       
X 1/2/2008 2:53:52 μμ ->   An exception occurred while executing a Transact-SQL statement or batch.       
X 1/2/2008 2:53:52 μμ -> SqlException       
X 1/2/2008 2:53:52 μμ ->   Invalid object name 'dbo.Transactions'.

Also the rest of the exceptions say that the package cannot verify indexes for the Transactions table, foreign keys for the Transactions table, and indexes for the TransactionsFullView view, which just failed  to create.

It looks like the package is trying to create the view and the table in the wrong order or, there's something wrong with my database. Either way I thought you might need to have as much information as I could provide you, to find out what is going on. I did this, because this is what I ask when one of my clients reports something that looks like a bug in my applications. I never wanted you analyze my table structure.

Take care

OK...there is nothing wrong with the DDT...the message that was given to you was given by SQL Server itself and it was related to the Fk_Employees_Transactions relationship that you had setup.  SQL Server was telling you that this was not a safe relationship because it would produce multiple-cycles on the cascades due to other relationships on these same fields from other foreign keys that were setup.  If you remove this relationship from the Employees table you will see that it will deploy without issue.  I did not sit down (nor is this something that we do) and analyze your table structures past determining where your issue resides.  I would revisit my relationships on my foreign key constraints to prevent a circular relationship from occuring.

I cannot import your package because there is a password on it and you did not provide it in your post or your .rar file.  You can email the password if you like.  Thanks.

I will look at your packages and see what is going on with your data.

Ths DDT is not that new of a package and is a tool that we use every day in the field distributing our medical software as well as StrataFrame structures and even our CRM structures....this has been used thousands of times in the field on practically every imaginable platform that you can think of.  So the DDT is a very solid and tried tool. 

Generally when you have a problem deploying something through the DDT it generally is because of some type of contraint of other rule that is being violated on the SQL Server side.

We use SMO (SQL Server Management Objects) to deploy the structures....so when you have errors, they are generally related to some SQL violation.  But I will look at your packages.

Hi there guys.

The whole thing started when I tried to modify a foreign key constraint. Then when trying to deploy the package I got an exception saying that a certain field (which is the primary key) could not be renamed because it was a member of a list. I have removed the constraint and add it again, and the same error.

After that I have removed the whole table and recreated it. Not I get four exceptions: One that says that a certain view (which depends on the table) could not be created because the table is not there. I have remove and recreated the view too, but still the same error.

The other two exceptions complain that they cannot verify the existence of the indexes in the table and view which I have removed and recreated.

The fourth complains about not being able to verify the existence of foreign keys in the table that has been removed and recreated.

Is there a chance that I'm doing something terribly wrong with DDT? I have imported the tables from a SQL2005 database and created all indexes and stored procedures and views manually in the DDT. After that all I do is modifying the schema. Is there a certain way I must be using the DDT tool? Is this because DDT is a rather new tool?

I have attached a rar file that contains my database, my StrataFrame database, the package, and the result log files of the deployments, in case you'll need to look more into it.

Thank you in advance.