MBR IT/.NET 247 : Installing Multiple Portals on 1 machine using same SQL server BUT different tables on ASPFriends.com 'aspngibuyspy' list

Installing Multiple Portals on 1 machine using same SQL server BUT different tables

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngibuyspy' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

John Colling

Hi guys,
Anyone know how to easily install multiple portals on the same machine =
?

Regards,

John Colling
Systems Administrator
Tonto Home Loans
PH: (07) 3017 8823
FX: (07) 3017 8800
MB: 0410 454 565
Click here to reveal e-mail address

Reply to this message...

Brian Bilbro (VIP)

My site is configured exactly like that:
http://www.aspalliance.com/bbilbro/DesktopDefault.aspx?tabindex=3D7&tabid=
=3D15

I share the same database as other alliance authors but I use my own =
tables. It's been awhile since I did it but I think it took me around =
2-4 hours to modify the setup scripts and the data access code.

--
Brian

----- Original Message -----
From: "John Colling" <Click here to reveal e-mail address>
To: Click here to reveal e-mail address
Sent: Fri, 26 Jul 2002 12:53:18 +1000
Subject: Installing Multiple Portals on 1 machine using same SQL server =
BUT different tables
[Original message clipped]

Reply to this message...

Dennis West

Brian do you remember how you did the modifications.for Multiple Portals.

----- Original Message -----
From: "Brian Bilbro" <Click here to reveal e-mail address>
To: "aspngibuyspy" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:57 PM
Subject: [aspngibuyspy] Re: Installing Multiple Portals on 1 machine using
same SQL server BUT different tables

My site is configured exactly like that:
http://www.aspalliance.com/bbilbro/DesktopDefault.aspx?tabindex=7&tabid=15

I share the same database as other alliance authors but I use my own tables.
It's been awhile since I did it but I think it took me around 2-4 hours to
modify the setup scripts and the data access code.

--
Brian

----- Original Message -----
From: "John Colling" <Click here to reveal e-mail address>
To: Click here to reveal e-mail address
Sent: Fri, 26 Jul 2002 12:53:18 +1000
Subject: Installing Multiple Portals on 1 machine using same SQL server BUT
different tables
[Original message clipped]

| [aspngibuyspy] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngibuyspy.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

Reply to this message...

Brian Bilbro (VIP)

WWVzLiAgIEkgZGlkIGl0IHR3byBzdGVwczogDQoNCjEuICBJIG1vZGlmaWVkIHRoZSBkYiBzZXR1
cCBzY3JpcHRzIHdpdGggbXkgb3duIHVuaXF1ZSBuYW1lcyAoaW4gbXkgY2FzZSwgSSBwcmVwZW5k
ZWQgQ0JCXyBpbiBmcm9udCBvZiBldmVyeSBzcCwgdGFibGUsIHZpZXcsIGV0Yy4uLikNCjIuICBJ
IG1vZGlmZWQgYWxsIG9mIHRoZSBkYXRhIGFjY2VzcyBjb2RlIHRvIGFjY2VzcyB0aGUgbmV3IG5h
bWVzLg0KDQotLQ0KQnJpYW4NCg0KDQotLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tIA0KRnJv
bTogIkRlbm5pcyBXZXN0IiA8d2VzdGRoQGF0dGJpLmNvbT4NClRvOiAiYXNwbmdpYnV5c3B5IiA8
YXNwbmdpYnV5c3B5QGFzcGZyaWVuZHMuY29tPg0KU2VudDogRnJpZGF5LCBKdWx5IDI2LCAyMDAy
IDk6MTIgUE0NClN1YmplY3Q6IFthc3BuZ2lidXlzcHldIFJlOiBJbnN0YWxsaW5nIE11bHRpcGxl
IFBvcnRhbHMgb24gMSBtYWNoaW5lIHVzaW5nIHNhbWUgU1FMIHNlcnZlciBCVVQgZGlmZmVyZW50
IHRhYmxlcw0KDQoNCj4gQnJpYW4gZG8geW91IHJlbWVtYmVyIGhvdyB5b3UgZGlkIHRoZSBtb2Rp
ZmljYXRpb25zLmZvciBNdWx0aXBsZSBQb3J0YWxzLg0KPiANCj4gLS0tLS0gT3JpZ2luYWwgTWVz
c2FnZSAtLS0tLQ0KPiBGcm9tOiAiQnJpYW4gQmlsYnJvIiA8YmJpbGJyb0Bob3RtYWlsLmNvbT4N
Cj4gVG86ICJhc3BuZ2lidXlzcHkiIDxhc3BuZ2lidXlzcHlAYXNwZnJpZW5kcy5jb20+DQo+IFNl
bnQ6IFRodXJzZGF5LCBKdWx5IDI1LCAyMDAyIDk6NTcgUE0NCj4gU3ViamVjdDogW2FzcG5naWJ1
eXNweV0gUmU6IEluc3RhbGxpbmcgTXVsdGlwbGUgUG9ydGFscyBvbiAxIG1hY2hpbmUgdXNpbmcN
Cj4gc2FtZSBTUUwgc2VydmVyIEJVVCBkaWZmZXJlbnQgdGFibGVzDQo+IA0KPiANCj4gTXkgc2l0
ZSBpcyBjb25maWd1cmVkIGV4YWN0bHkgbGlrZSB0aGF0Og0KPiBodHRwOi8vd3d3LmFzcGFsbGlh
bmNlLmNvbS9iYmlsYnJvL0Rlc2t0b3BEZWZhdWx0LmFzcHg/dGFiaW5kZXg9NyZ0YWJpZD0xNQ0K
PiANCj4gSSBzaGFyZSB0aGUgc2FtZSBkYXRhYmFzZSBhcyBvdGhlciBhbGxpYW5jZSBhdXRob3Jz
IGJ1dCBJIHVzZSBteSBvd24gdGFibGVzLg0KPiBJdCdzIGJlZW4gYXdoaWxlIHNpbmNlIEkgZGlk
IGl0IGJ1dCBJIHRoaW5rIGl0IHRvb2sgbWUgYXJvdW5kIDItNCBob3VycyB0bw0KPiBtb2RpZnkg
dGhlIHNldHVwIHNjcmlwdHMgYW5kIHRoZSBkYXRhIGFjY2VzcyBjb2RlLg0KPiANCj4gLS0NCj4g
QnJpYW4NCj4gDQo+IA0KPiAtLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tDQo+IEZyb206ICJK
b2huIENvbGxpbmciIDxqb2huY0B0b250by5jb20uYXU+DQo+IFRvOiBhc3BuZ2lidXlzcHlAYXNw
ZnJpZW5kcy5jb20NCj4gU2VudDogRnJpLCAyNiBKdWwgMjAwMiAxMjo1MzoxOCArMTAwMA0KPiBT
dWJqZWN0OiBJbnN0YWxsaW5nIE11bHRpcGxlIFBvcnRhbHMgb24gMSBtYWNoaW5lIHVzaW5nIHNh
bWUgU1FMIHNlcnZlciBCVVQNCj4gZGlmZmVyZW50IHRhYmxlcw0KPiA+DQo+ID5IaSBndXlzLA0K
PiA+IEFueW9uZSBrbm93IGhvdyB0byBlYXNpbHkgaW5zdGFsbCBtdWx0aXBsZSBwb3J0YWxzIG9u
IHRoZSBzYW1lIG1hY2hpbmUgPw0KPiA+DQo+ID4NCj4gPg0KPiA+UmVnYXJkcywNCj4gPg0KPiA+
Sm9obiBDb2xsaW5nDQo+ID5TeXN0ZW1zIEFkbWluaXN0cmF0b3INCj4gPlRvbnRvIEhvbWUgTG9h
bnMNCj4gPlBIOiAoMDcpIDMwMTcgODgyMw0KPiA+Rlg6ICgwNykgMzAxNyA4ODAwDQo+ID5NQjog
MDQxMCA0NTQgNTY1DQo+ID5qb2huY0B0b250by5jb20uYXUNCj4gPg0KPiANCj4gfCBbYXNwbmdp
YnV5c3B5XSBtZW1iZXIgd2VzdGRoQGF0dGJpLmNvbSA9IFlPVVIgSUQNCj4gfCBodHRwOi8vd3d3
LmFzcGxpc3RzLmNvbS9hc3BsaXN0cy9hc3BuZ2lidXlzcHkuYXNwID0gSk9JTi9RVUlUDQo+IHwg
aHR0cDovL3d3dy5hc3BsaXN0cy5jb20vc2VhcmNoID0gU0VBUkNIIEFyY2hpdmVzDQo+IA0KPiAN
Cj4gDQo+IHwgW2FzcG5naWJ1eXNweV0gbWVtYmVyIGJiaWxicm9AaG90bWFpbC5jb20gPSBZT1VS
IElEDQo+IHwgaHR0cDovL3d3dy5hc3BsaXN0cy5jb20vYXNwbGlzdHMvYXNwbmdpYnV5c3B5LmFz
cCA9IEpPSU4vUVVJVA0KPiB8IGh0dHA6Ly93d3cuYXNwbGlzdHMuY29tL3NlYXJjaCA9IFNFQVJD
SCBBcmNoaXZlcw0KPiANCj4gDQo=

Reply to this message...

John R. O'Brien

Your approach is different from the approach described here.

ENHANCEMENT: How do I run multiple portals from a single database in VB? =
RTM - Updated 9 May 2002
http://aspsmith.com/DesktopDefault.aspx?tabindex=3D2&tabid=3D32

This implementation is in vb so I'm changing and enhancing the =
implementation to cs to match my portal, but I think the idea is sound. =
Any thoughts on this approach while I'm poking around in the code =
anyway?

Did you create your own database or just duplicate everything with a =
prefix and modify your portal data access layer?

And, I need to easily add new portals and stores into the same existing =
infrastructure, basically shared or multi hosting.=20

So, whipping the code up on the jacks to swap the db out for each new =
customer won't work for me, I have admins who are adding the portals and =
stores for customers. I need to make it simple for them and then I need =
to continue to develop my additional user controls to match our value =
add.

Thanks for your thoughts on this.

John R. O'Brien
Home 410 352 3614
Cell 443 497 2017
FAX 801 849 7589
=20

-----Original Message-----
From: Brian Bilbro [mailto:Click here to reveal e-mail address]=20
Sent: Friday, July 26, 2002 9:39 AM
To: aspngibuyspy
Subject: [aspngibuyspy] Re: Installing Multiple Portals on 1 machine =
using same SQL server BUT different tables

Yes. I did it two steps:=20

1. I modified the db setup scripts with my own unique names (in my =
case, I prepended CBB_ in front of every sp, table, view, etc...)
2. I modifed all of the data access code to access the new names.

--
Brian

----- Original Message -----=20
From: "Dennis West" <Click here to reveal e-mail address>
To: "aspngibuyspy" <Click here to reveal e-mail address>
Sent: Friday, July 26, 2002 9:12 PM
Subject: [aspngibuyspy] Re: Installing Multiple Portals on 1 machine =
using same SQL server BUT different tables

> Brian do you remember how you did the modifications.for Multiple =
Portals.
[Original message clipped]

=3D15
[Original message clipped]

=C3=9C=C2=A1=C3=86r` =
=C2=B6=C3=83=C2=B2=C2=B2=C2=A2=C2=B2=C2=B2j=E2=80=9A=C3=8A

Reply to this message...

Brian Bilbro (VIP)

LS0tLS0gT3JpZ2luYWwgTWVzc2FnZSAtLS0tLSANCkZyb206ICJKb2huIFIuIE8nQnJpZW4iIDxq
b2huQG9jZWFuY2l0eWxvY2FsLmNvbT4NClNlbnQ6IEZyaWRheSwgSnVseSAyNiwgMjAwMiAxMDoy
MiBBTQ0KDQoNCj5Zb3VyIGFwcHJvYWNoIGlzIGRpZmZlcmVudCBmcm9tIHRoZSBhcHByb2FjaCBk
ZXNjcmliZWQgaGVyZS4NCg0KVGhhdCdzIGNvcnJlY3QuICBUaGV5IGFyZSBkaWZmZXJlbnQuICBB
bmQgdGhleSBhcmUgbm90IHJlYWxseSAiZGlmZmVyZW50IGFwcHJvYWNoZXMiLiAgVGhleSBhcmUg
ZGlmZmVyZW50IGRlc2lnbnMgZm9yIGRpZmZlcmVudCByZXF1aXJlbWVudHMuICAgSSBkaWRuJ3Qg
bWVudGlvbiB0aGF0IGVuaGFuY2VtZW50ICBiZWNhdXNlIGhlIGFza2VkIGhvdyB0byBydW4gIk11
bHRpcGxlIFBvcnRhbHMgb24gMSBtYWNoaW5lIHVzaW5nIHNhbWUgU1FMIHNlcnZlciBCVVQgZGlm
ZmVyZW50IHRhYmxlcyIuICBUaGF0IGxhc3QgcGFydCBpcyBrZXkuICBIZSB3YW50cyBkaWZmZXJl
bnQgdGFibGVzIGZvciBlYWNoIHBvcnRhbC4gIFRoYXQncyBob3cgSSBoYXZlIG15IHNpdGUgY29u
ZmlndXJlZC4gICBUaGUgZW5oYW5jZW1lbnQgeW91IG1lbmV0aW9ucyB1c2VzIHRoZSBzYW1lIHRh
YmxlcyBhbmQgdGhhdCBpcyBub3Qgd2hhdCBoZSBpcyBhc2tpbmcgZm9yLg0KDQotLQ0KQnJpYW4N
Cg==

Reply to this message...

Brian Desmond

I posted a message to the list a few weeks back detailing how to do
this. If I can find it, I'll repost it - otherwise, it should be in the
list archive though.

--Brian Desmond
Click here to reveal e-mail address

-----Original Message-----
From: Dennis West [mailto:Click here to reveal e-mail address]
Sent: Friday, July 26, 2002 7:13 PM
To: aspngibuyspy
Subject: [aspngibuyspy] Re: Installing Multiple Portals on 1 machine
using same SQL server BUT different tables

Brian do you remember how you did the modifications.for Multiple
Portals.

----- Original Message -----
From: "Brian Bilbro" <Click here to reveal e-mail address>
To: "aspngibuyspy" <Click here to reveal e-mail address>
Sent: Thursday, July 25, 2002 9:57 PM
Subject: [aspngibuyspy] Re: Installing Multiple Portals on 1 machine
using
same SQL server BUT different tables

My site is configured exactly like that:
http://www.aspalliance.com/bbilbro/DesktopDefault.aspx?tabindex=7&tabid=
15

I share the same database as other alliance authors but I use my own
tables.
It's been awhile since I did it but I think it took me around 2-4 hours
to
modify the setup scripts and the data access code.

--
Brian

----- Original Message -----
From: "John Colling" <Click here to reveal e-mail address>
To: Click here to reveal e-mail address
Sent: Fri, 26 Jul 2002 12:53:18 +1000
Subject: Installing Multiple Portals on 1 machine using same SQL server
BUT
different tables
[Original message clipped]

| [aspngibuyspy] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngibuyspy.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

| [aspngibuyspy] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngibuyspy.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/1/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/1/2002

Reply to this message...

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com