Re: Multiple Application Membership/Profiles in SQLServer?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Tue, 20 Feb 2007 11:22:44 -0600, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote:

Either direction is fine. If you are going to have multiple apps in one DB,
I would have the database as a Membership only database (you can add
profile, etc., but no custom tables0.

If you want to create multiple dbs (one for each app), that is fine also.
Just run the script on each DB.

Thanks, I ended up going the multiple db route. I think that doing
stuff like updating my PC from production or moving the stuff to a
home PC is just going to be a nightmare with multiple apps in one db.

I see no downside in just having a separate db for each app.
.

Relevant Pages

  • Re: Restated: "Fields are expensive, records are cheap"
    ... The mantra in the subject line is purely a rule-of-thumb for beginning database designers. ... You're saying that there is a delay to move the disk heads to different physical locations to retrieve records, and that delay represents degraded performance. ... split a large normalize row in a single table into multiple rows in multiple ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Number of users
    ... While there might be a valid reason to open ... Access multiple times, and mind you, I can't think of one, it is not ... having multiple instances of the same database open. ... "Be who you are and say what you feel, because those who mind don't matter ...
    (microsoft.public.access.modulesdaovba)
  • Detect Database Version prior to opening db
    ... I am working on developing an access db that will be shared among multiple ... Many people that will be using this app have both access 97 and access ... I can get the version of the db on a Form Load event with either ... database, if they have access 97 setup as their default db. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Question about remote objects
    ... database service with connection to database ... client manager to service logins from client workstations ... the server. ... a row read in from the database, and with multiple users running multiple ...
    (comp.lang.python)
  • Re: Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ... You might consider checking licensing costs at the oracle store ...
    (comp.databases.oracle.server)