Hi,

Pls refer to the following errors that I got when I deploy a package to SQL Server using Database Deployment Wizard. These errors only occured when I run the wizard for the 2nd time but it works fine for the 1st time without any error.

Senarioes

1. The database already exist at SQL Server(eg:VfsMain) and I run the wizard for the 2nd time using the same package but I renamed the Database Name on Server to another name(eg:VfsMain2). I hit this error as per attached (FlexHRDatabase_results4.rtf).

2. The database already exist at SQL Server and I run the wizard again for the 2nd time using the same package. I hit this error as per attached (FlexHRDatabase_results1.rtf).

Pls kindly advice.Thanks.

Hi,

For 2nd issue, error while deploy data. I have attached my package, DDT log and step to reproduce.

Please advice ASAP.



Database Deployment Toolkit



1.Import two databases, VfsLocalization and VfsSecurity.

2.Created deployment data for tables,MessageItems & MessageLanguages from VfsLocalization and deployment data for tables,SFSPreferences & SFSPreferencesChild from VfsSecurity.

3.Create package.



Database Deployment Wizard



1.Run and select the package that I have created.

2.Complete the whole process for the 1st time,everything runs smoothly.

3.Run and select the package for the 2nd time using the wizard.

3.The whole process completed with errors.Pls refer to attachment(Test_results1.rtf)





Thank you