Submit Your Article Forum Rules
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: shared database

  1. #1

    shared database

    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 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.

  2. #2

    Re: shared database

    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 Hidden Content as added security for my networks and servers.

  3. #3

    Re: shared database

    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,

  4. #4
    WebProWorld MVP kgun's Avatar
    Join Date
    May 2005
    Blog Entries
    Hidden Content :: Hidden Content
    Hidden Content
    Conversations creates communities and conversions create profit.

  5. #5

    Re: shared database

    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

    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 product to php? I am just at a loss in what direction to go.

  6. #6

    Re: shared database

    You could do it by having a single database, and adding 2 fields- "SITE 1" and "SITE 2" When someone signs up at site #1, you build the record, and set "SITE 1" to true. Same for Site 2. If someone from one site wants to register at the other, they can enter their login, but get a message asking if they want to be registered under the same name at this site as well. Once paid, you would set the flag for the second site. You would just have to add logic to check for the proper flag at login time to both sites, but you would have a single, integrated database.
    Accept Credit Cards Anywhere!
    Hidden Content

  7. #7

    Re: shared database

    I think this will work. did u try it? please tell us what happened because i want to use this also

  8. #8

    Re: shared database

    We have not tried as yet. We are looking for someone to do this. We have a bid request out with a few different areas, rentacoder and elance to see what the cost would be. Will let you know

  9. #9

    Re: shared database

    i prefer having the login info located in one db (mysql) and the rest on the other db (mssql) and then have the application use both db.

  10. #10

    Re: shared database

    I am interested in seeing how this shakes out. I have a similar senerio where I have a MySQL CRM and an accounting system on MS SQL Server that need to communicate

Similar Threads

  1. Shared hosting and unlimited database access?
    By stacee in forum Webmaster Resources Discussion Forum
    Replies: 4
    Last Post: 03-10-2010, 10:32 PM
  2. Automatic database backup very large database
    By infomania in forum Database Discussion Forum
    Replies: 2
    Last Post: 12-20-2009, 03:24 AM
  3. Using Shared Borders
    By Andy Romano in forum Search Engine Optimization Forum
    Replies: 1
    Last Post: 10-29-2005, 06:11 PM
  4. Shared reciprocal links database ok?
    By eggypiece in forum Google Discussion Forum
    Replies: 0
    Last Post: 11-24-2004, 08:52 PM
  5. How shared is shared..?
    By Dragonsi in forum IT Discussion Forum
    Replies: 9
    Last Post: 05-23-2004, 05:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts