Changing Filename on Database originally imported into DDT


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
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







Replies
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Hey, not difficult. Poked around a bit in the Stratafame database. In the DBEDataFiles table the fil_name field for that project just needs to be changed from the hard-coded Membership_Data to the $DBName$ token.



Really really like the DDT.







Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
OK...question....do you just LIVE at your computer? BigGrin  Oh wait, I just responded to your post Hehe
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