|
|
||||||
|
||||||
| Index Link To US Private Messages Archive FAQ RSS | ||||||
| Database Discussion Forum This is the place to find help resolving those nagging questions you have about implementing and using all kinds of databases. Need help writing a query? Need an opinion on Oracle? Post here! |
Share Thread: & Tags
|
||||
|
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
|
I am not a real tech person so I really could use some help in reference to databases.
I have two different web sites. One is php and the other is asp.net. Not real smart I know have two different formats. Did not know any better at the time. So my question is I want to be able to have the databases talk to each other so the members will only have to log in once and have only one membership. One database is mssql and the other is mysql is this possible? If so please explain so I can see about doing or hiring someone. |
|
|||
|
Yes this is possible. You could set up the user validation within one website and have it act as the clearing house for user data. There really is no need to have both databases talk to eash other unless you plan to keep separate user data.
A simple connection to the database holding the credentials will take care of the matter. Assuming the databases are on the same server it is a piece of cake. If they reside on different servers it will work almost as easily. Just make sure the chosen database can handle remote connections.
__________________
I use Country IP Blocks as added security for my networks and servers. |
|
|||
|
Another alternative could be to write a bridge script of some sort that will automatically keep both websites in synch. You can also write a export script that will transfer data from one to the other and set this up as a cronjob,
__________________
Web design Company | Estate agent website | E-Commerce & Search engine marketing | |
|
||||
|
There may already be a database connection class ready for you:
Class: Database Connection Classes (database, connection, database class, mysql connection) - PHP Classes Relevant article: The PHP Anthology Volume 1, Chapter 2 - Object Oriented PHP [PHP & MySQL Tutorials] more precisely page 10. The PHP Anthology Volume 1, Chapter 2 - Object Oriented PHP [PHP & MySQL Tutorials] |
|
|||
|
Thank you for all of the help. I might not of explained real well.
Here is what I am thinking about. I have two web sites with two different databases of membership. One is php and the other is asp.net. Here are my thoughts since both sites attract the same clients I wanted to make different memberships available. One would be to site 1 and the other would be to site 2 with a third option of a combo membership to site 1 and 2. This would be for existing and new members. All of this to be managed from just one admin area with one payment area and of course just one sign in to access the areas they are approved to access depending on the membership program each has. I hope that this makes things a little clearer. Am I looking at a major project and major expense? I hope that this is all workable and not to expensive. Would it be easier to re write the asp.net product to php? I am just at a loss in what direction to go. |
|
|||
|
Those options seem to be some good advice you should use. Have you sorted out the migration of both database and how you will deal with the different formats? Maybe exporting them and then uploading them together in the same table.
|
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Shared Borders | Andy Romano | Search Engine Optimization Forum | 1 | 10-29-2005 05:11 PM |
| Fixed or shared IP | onelife | Search Engine Optimization Forum | 10 | 10-03-2005 08:17 PM |
| Shared reciprocal links database ok? | eggypiece | Google Discussion Forum | 0 | 11-24-2004 07:52 PM |
| How shared is shared..? | Dragonsi | IT Discussion Forum | 9 | 05-23-2004 04:37 PM |
| Shared Printers? | tammster37601 | IT Discussion Forum | 4 | 03-18-2004 09:22 PM |
|
WebProWorld |
Advertise |
Contact Us |
About |
Forum Rules |
MVP's |
Archive |
Newsletter Archive |
Top |
WebProNews
WebProWorld is an iEntry, Inc. ® site - © 2009 All Rights Reserved Privacy Policy and Legal iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509 |