Updating Security, Two Databases & One .mdw

[saip15]

Hi everyone,

Background: I had a split database with ULS and everything was working great. I wanted to add some forms to the database so I thought it would be easier to make a second database that wasn't split. So I brought the FE and BE back together in a separate DB. As you all know having a back-up of everything is your best friend.

Question: I wanted to see what happened when I tried to use the .mdw file for the original split database on the new DB. When I open the new DB, on the permissions, all of the tables and forms got updated but all of my permissions got reset and the Users group has all the permissions. But when i open the original split database the permissions are correct and how I set them.

Does the .mdw file recognize which DB is open and adjust the permissions?

If I want to add information to a secure DB how will the .mdw recognize the new tables/forms and I have to update the permissions for the new tables/forms manually correct?

Should I go ahead and make a new .mdw file for the new DB? Instead to trying to make changes to my original DB.

Thanks so much!

 

[HiTechCoach]

So I brought the FE and BE back together in a separate DB. As you all know having a back-up of everything is your best friend.

I would not have merge them back. There was really no need. IMHO, you made it harder to make backups and to test. I would never un-split any database to develop on it. I think it make it more difficult.


I would have just made a copy of the front end, back end, and .MDW file. Relink the copy of the front end to the copy of the back end. create a shortcut to open the front end with the copy or the same shared .MDW file and start making changes.

When done, relink the new front end to the original (live) back end. Apply any table changes to the live back end. deploy the new front end.

Should I go ahead and make a new .mdw file for the new DB? Instead to trying to make changes to my original DB.

I would say no.

 

[saip15]

Ok, Thanks HiTechCoach! So I should just import the appropriate tables/forms back into original the FE/BE? I thought I would get everything working and then add it to the split database. Thanks so much!