Two domains, One Database

Sort of a newby, so here goes:

Can two domains with separate hosting accountsshare a single database? So that www.overhere.com and www.overthere.net can both pull content from a single SQL db?

My client has a public hosted site and a private intranet site (both hostedat discountasp.net)and am wondering if this is possible. The public would see limited catalog info on the public hosted site - coming from the db, and the vendors could see entire catalog info on the privateintranet coming from the same db. The private intranet would also have an Admin tool for employees to update the catalog db.

Is there a way to avoid having redundant databases for each domain?

Thanks for any insight,
Doug

 

Hi,
You can do this, just prefix your tables and objects with something or each site so you don't cross wires.
i.e. Table names: fn_rootnames, sn_rootnames...fn_members, sn_members.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx