Hi,
I'm having issues when trying to execute a package through StrataFrames DLLs.
I have the following scenario
2Databases:
Database1Database2Database2 was imported into StrataFrame DDT profile - profile name is '
DDTProfile'.
The file name in the data files of the filegroup 'PRIMARY' is set to '$
DbName$'
I set a pre deployment script to drop 'table1'
A package was created from DDT and executed through the following code:
DatabaseTargetName dbToUpdate = new DatabaseTargetName("
DDTProfile");
dbToUpdate.NameOnServer = "
Database1";
_dbMigrator.DeployMetaData(@"D:\DevPackages\Package.pkg", "", new DatabaseTargetName[]{ dbToUpdate });
I understand that when executed, this package should drop '
table1' from '
Database1', which isn't doing.
Instead, it is dropping the table from '
Database2'.
Below please find a sample of the log which the DDT returns in the ProgressUpdate event:
Database Progress Update:99% completed - Ensuring Views, Stored Procedures, and UDFs Complete - View, Stored Procedure, and UDF verification complete.
Database Progress Update:99% completed - Ensuring View Indexes for 'Database2' - Ensuring Indexes exist on database 'Database2'Database Progress Update:99% completed - Ensuring View Indexes Complete - Index verification complete.
Am I missing something here?