LockedIntegrating /w Existing DB (more than Membership)

Author
pinch
vNext Owner
  • Total Posts : 96
  • Reward points : 11085
  • Joined:
  • Status: offline
0

Integrating /w Existing DB (more than Membership)

I see quite a few threads regarding integrating ASPPlayground.NET with existing membership providers, but I'm specifically trying to integrate ASPPlayground into my existing database itself.  I have much more than the default membership in my database so I'd want to completely merge this database with the schema/SPs/etc from ASPPlayground.

This wouldn't be a big deal if my host didn't charge for every extra database (regardless of size), but that is how DiscountASP operates.
#1
APGvNext (Sam)
vNext Dev
  • Total Posts : 12482
  • Reward points : 218330
  • Joined:
  • Status: offline
Re:Integrating /w Existing DB (more than Membership) (permalink)
0
What you can do is create a different user in the existing db, and use this user specifically for ASPPlayground (to run setup, and to use the forum). This way, there won't be any problem mixing the db objects together.
#2
pinch
vNext Owner
  • Total Posts : 96
  • Reward points : 11085
  • Joined:
  • Status: offline
Re:Integrating /w Existing DB (more than Membership) (permalink)
0
How difficult would it be to strip-out the schema/data after the forum as been in production for awhile?   I'm trying to determine if paying an extra $120/year for an addition database would be worthwhile but its tough without knowing the resources required for the forum or how hard it would be to move the schema to its own database in the future, if necessary.
#3
APGvNext (Sam)
vNext Dev
  • Total Posts : 12482
  • Reward points : 218330
  • Joined:
  • Status: offline
Re:Integrating /w Existing DB (more than Membership) (permalink)
0
If you follow what I mentioned in the message above, the forum's object would have a schema different from the rest of the db objects. It will be very easy to differentiate which resources belong to the forum and the site.

If later you want to move forum objects to another db, you can create an empty db with the full installation script and then export data from the old db.
#4
Guest
Super Member
  • Total Posts : 958
  • Reward points : 0
  • Joined:
  • Status: online
Re:Integrating /w Existing DB (more than Membership) (permalink)
0
just a question: are the forum db tables prefixed in a certain way? I haven't tested the demo, fyi.
#5
Jump to:
© 2013 APG vNext Commercial Version 4.3