Executing a package for different database name not working

Melvin Xuereb — Thu, 25 Nov 2010 04:54:26 GMT

Hi,

I'm having issues when trying to execute a package through StrataFrames DLLs.

I have the following scenario

2Databases:

Database1

Database2

Database2 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?

Thanks,

Melvin

RE: Executing a package for different database name not working

Ivan George Borges — Thu, 25 Nov 2010 04:54:26 GMT

You're welcome. :cool:

RE: Executing a package for different database name not working

Melvin Xuereb — Thu, 25 Nov 2010 04:45:46 GMT

Thanks!! Case sensitivity problem too!

Melvin

RE: Executing a package for different database name not working

Ivan George Borges — Thu, 25 Nov 2010 03:29:11 GMT

Hi Melvin.

Hard to say just looking at your post. But for a starter, follow the thread from the post bellow and you will find some points you can check on your project:

http://forum.strataframe.net/FindPost20018.aspx

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Executing a package for different database name not working

Executing a package for different database name not working

RE: Executing a package for different database name not working

RE: Executing a package for different database name not working

RE: Executing a package for different database name not working