Moved DDT to another box - pkg from 1st box won't deploy

Charles R Hankey — Tue, 19 Aug 2008 11:43:12 GMT

I realize I probably mucked something up here, but thought I might get a better understanding of DDT metadata by asking this question while on a non-critical issue :

I moved my Strataframe installation from my laptop to my desktop. i detached the strataframe.mdf and reattached on new box.

I took a package created on the 1st box (but never deployed) and brought it over to the 2nd box and imported it into a new profile.

SQL Server on box 2 does't not have a database Netpark

I try to deploy the package and get this
[quote]
• 8/19/2008 11:05:46 AM-> Deploying meta-data for database 'Netpark'
X 8/19/2008 11:05:46 AM-> Creating database 'Netpark' failed.
X 8/19/2008 11:05:46 AM-> FailedOperationException
X 8/19/2008 11:05:46 AM-> Create failed for Database 'Netpark'.
X 8/19/2008 11:05:46 AM-> SmoException
X 8/19/2008 11:05:46 AM-> The PRIMARY filegroup must have at least one file.
X 8/19/2008 11:05:46 AM->
X 8/19/2008 11:05:46 AM-> Source : Microsoft.SqlServer.Smo
X 8/19/2008 11:05:46 AM->
X 8/19/2008 11:05:46 AM-> Stack Trace:
X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.FileGroup.ScriptDdl(ScriptingOptions so, StringBuilder ddl, Boolean databaseIsView)
X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.Database.GetFileGroupsScript(StringBuilder query, Boolean databaseIsView, StringCollection emptyfgs, ScriptingOptions so)
X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.Database.ScriptCreate(StringCollection createQuery, ScriptingOptions so)
X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ScriptCreateInternal(StringCollection query, ScriptingOptions so)
X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CreateImpl()
X 8/19/2008 11:05:46 AM-> at Microsoft.SqlServer.Management.Smo.Database.Create()
X 8/19/2008 11:05:46 AM-> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging)
X 8/19/2008 11:05:46 AM->
• 8/19/2008 11:05:46 AM-> Finished verifying databases on server.
• 8/19/2008 11:05:46 AM-> The meta data conversion to the SQL Server has been completed.
[/quote]

I do see PRIMARY under filegroups in the profile.

Not sure what the DDT is complaining about, but no database is getting deployed

Thoughts?

RE: Moved DDT to another box - pkg from 1st box won't deploy

Charles R Hankey — Tue, 19 Aug 2008 11:43:12 GMT

Thanks Trent - that indeed did the trick

For lurkers : I right clicked the PRIMARY file group in the right column (after selecting Filegroups) There was no choice to EDIT but I clicked ADD and it created a $dbname$ entry as Trent said.

After saving the name of my database was substituted.

Package now deploys with not problem.

RE: Moved DDT to another box - pkg from 1st box won't deploy

Trent L. Taylor — Tue, 19 Aug 2008 10:33:57 GMT

Well, it appears (for whatever reason) that the data file underneath the Primary file groups doesn't exist. You have the primary file group, but there is not a specific data file defined underneath it...does that make sense?

Just select the PRIMARY file group, then add a data file underneath it with the standard $dbname$ and default settings and then try to re-deploy and you should be good to go.

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Moved DDT to another box - pkg from 1st box won't deploy

Moved DDT to another box - pkg from 1st box won't deploy

RE: Moved DDT to another box - pkg from 1st box won't deploy

RE: Moved DDT to another box - pkg from 1st box won't deploy