close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Combine multiple databases in a parent database

Thread began 11/28/2014 9:58 am by Erin | Last modified 12/02/2014 1:58 pm by Jason Byrnes | 248 views | 3 replies |

Erin

Combine multiple databases in a parent database

Hello, I am searching for the easiest way to take multiple databases and have them appear in a single parent database, including updated information after the individual databases are updated. Is there an easy way to do this? For a bit more context, all of the databases have the exact same structure and wouldn't need to have any alterations. I thought there might be a way to do this within MySQL itself. If not, I also have used DataAssist to create results and update pages for each of the individual databases, so perhaps it is easiest to update my code on the update page?

Thanks for any assistance!

Sign in to reply to this post

Jason ByrnesWebAssist

No, there is not an easy way to combine databases.

You would need to create queries to return data from each database table.

Using Data Assist, you would need to create a separate set of pages for each database.

Sign in to reply to this post

Erin

Okay, thank you for the response. Just to clarify, I have created a separate set of pages for each table (all within same database), and I just want to find a way to view all of these entries on one page. So, is there any way to have the updates occur simultaneously in original table and a new table? Or would I be better off developing a page that displays multiple tables?

Sign in to reply to this post

Jason ByrnesWebAssist

The wizard won't create pages that manage multiple tables at the same time, if you like, you can create the pages your self creating the necessary recordset, forms, and adding the nasally update behaviors, but there is not an automated way to create this.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...