Hi,

Our developers have spent few days to test on DDT and found some unclear issue as below and would like to ask for clarification:



Scenarios

----------

1.Created 1st package to create the db structure and deployment data, and run the wizard to deploy the database.

Then create another new package,2nd package with the same db structure and deployment data to deploy the database

pointing to the same db that have been created using the 1st package.Error will occured(eg:FlexHRDatabase_results.log)



2.Created package using DDT and remove any one of the database from the DDT and deploy the package again.

An error will occured if click deploy the package. This happen even though I have deleted the db deletion history.



3.Import Security table to a database using DDT.When import the security table for the 2nd time to the same database,

it will create another table for all the tables which are defined the table relationship and a message prompt out to inform

that "Relationship name: Relationship with this name already exists in the database".

Then, it will create additional new tables with same name instead of updating to the existing table.This will only occur if the table has relationship. If the table is without any relationship, it will just update to the same table without creating a duplicate new table.



Any ideas? Please advice.



Thank you

The priority is required, but it should not be deployed with a null value. The default priority for stored procedures is 10, and should be at least 1 if edited, so it set to NULL after deployment it is an erroronious state.  Try deleting the erronious stored procedure via SQL management studio and see how that affects the deployment.

If you can create a package using the new beta build that consistently deploys a sproc with a null value then by all means attatch it here, I'd like to be able to get in and give you a more specific answer. As it stands however, I can't deploy the package you sent to Trent for the reasons I already listed. We can't deploy a DDT package created on versions of Strataframe prior to the current beta build due to structure changes in the package file. Sending me the old package file does no good as I can't deploy it on my side.

My guess is that the deployment failed in the past and left the orphaned sproc out there which is giving you the problems, but I can't confirm this based soley on log files.

No, the pre-exsiting stored procedures are not created using DDT. They are created using CREATE PROCEDURE command, which maintain by us before using DDT. Beside, I found that, the priority field is extended property added by DDT, and not standard SQL Server field. Therefore, any SP deployed previously (not using DDT) would not have any value on it. That is the reason for the error. Do you think this is a "limitation", which need to be enhanced? Or, do you think DDT would not support to deploy any SP which previously not deployed using DDT?



Please advice. Thank you