Executing a package for different database name not working


Author
Message
Melvin Xuereb
Melvin Xuereb
StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)
Group: Forum Members
Posts: 29, Visits: 128
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



               
Tags
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
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
Melvin Xuereb
Melvin Xuereb
StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)
Group: Forum Members
Posts: 29, Visits: 128
Thanks!! Case sensitivity problem too!

Melvin
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)Strategic Support Team Member (2.2K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
You're welcome. Cool
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search