Executing a package for different database name not working

StrataFrame Forum

Back

Executing a package for different database name not working

Author	Message
Melvin Xuereb	Melvin Xuereb posted 14 Years Ago Topic Details Share Topic
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 DDT
	Reply Like 2
Ivan George Borges	Ivan George Borges posted 14 Years Ago Post Details Share Post
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
	Reply Like 2
Melvin Xuereb	Melvin Xuereb posted 14 Years Ago Post Details Share Post
Group: Forum Members Posts: 29, Visits: 128	Thanks!! Case sensitivity problem too! Melvin
	Reply Like 2
Ivan George Borges	Ivan George Borges posted 14 Years Ago Post Details Share Post
Group: StrataFrame MVPs Posts: 1.9K, Visits: 21K	You're welcome.
	Reply Like 2