StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » Changing Filename on Database originally imported into DDT

Changing Filename on Database originally imported into DDT

Charles R Hankey — Mon, 15 Feb 2010 07:42:44 GMT

I imported SQL Database Membership into DDT in a project called PDSM.NET

I changed the database name to PDSM and made a lot of changes to the schema.

This will never be used to maintain the shema of Membership but is entirely for creating a new database PDSM on a server.

I have deleted all the change history. I can deploy the database to the server as PDSM but the logical filename and the MDF are still Membership_Data.mdf.

How do I clean this out once and for all so the MDF file will be PDSM_data.MDF on deployment ?

TIA

RE: Changing Filename on Database originally imported into DDT

Trent L. Taylor — Mon, 15 Feb 2010 07:42:44 GMT

Hey, that's pretty impressive, and would be a good trick to learn. I imagine it would be easier for me to shave off a few pounds that way (just drop a byte or two)! :D

RE: Changing Filename on Database originally imported into DDT

Charles R Hankey — Mon, 15 Feb 2010 06:16:58 GMT

Actually I live [u]in[/u] my computer. Serialized myself into a byte array ...

Pretty impressive support though when on a Sunday you answer a question a guy who is talking to himself asks while he is answering himself. :P

RE: Changing Filename on Database originally imported into DDT

Trent L. Taylor — Sun, 14 Feb 2010 21:05:30 GMT

OK...question....do you just LIVE at your computer? :D Oh wait, I just responded to your post :hehe:

RE: Changing Filename on Database originally imported into DDT

Charles R Hankey — Sun, 14 Feb 2010 21:01:11 GMT

Hey, not difficult. Poked around a bit in the Stratafame database. In the[b] DBEDataFiles[/b] table the [b]fil_name [/b]field for that project just needs to be changed from the hard-coded Membership_Data to the [b]$DBName$[/b] token.

Really really like the DDT.

RE: Changing Filename on Database originally imported into DDT

Trent L. Taylor — Sun, 14 Feb 2010 20:55:55 GMT

Well, when you import a database from an actual deployed instance, it is going to bring in the file name assigned. So just open up the file names in the profile and implement the $DbName$ wildcard so that anywhere that you add that wildcard, the name of the database will be used upon deployment. This would be my primary suggestion here.