brucewin
Posts: 143
|
| Posted: 12/21/2005, 5:47 AM |
|
I am using PHP MySql Apache XAMPP on my desktop. I am adding tables and fields using MySQL-Front.
Does anyone use any products that can duplicate the tables and fields in your desktop environment to automatically change the database structure on a hosted web server that would match the desktop database structure of a particular CCS application, or the entire database?
Bruce
|
 |
 |
bou63
Posts: 9
|
| Posted: 12/21/2005, 6:05 AM |
|
Hello brucewin,
http://www.sqlmanager.net/en/products/mysql/dbcomparer
Bo
_________________
Bo |
|
|
|
brucewin
Posts: 143
|
| Posted: 12/21/2005, 7:17 AM |
|
Thanks Bo, looks good.
You can view all the differences in compared database objects and execute an automatically generated script to eliminate all or selected differences.
Does this above statement from DB Comparer mean that if on one server you can have 1 table including fields and the other server 15 tables including fields, you can generate a script to duplicate the one with 15 tables? Then upload a CCS project which should then work like it does on your desktop. All you would have to do then is put in the data.
Bruce
|
|
|
|
fotrane
Posts: 13
|
| Posted: 12/21/2005, 7:17 AM |
|
There are some good free solutions out there, but if you want to fork out a little cash, I have found these two to be very useful:
SQLYog: http://www.webyog.com
Navicat: http://www.navicat.com <-- Drag and Drop data replication/transfer (very nice)
|
|
|
|
brucewin
Posts: 143
|
| Posted: 12/22/2005, 5:04 AM |
|
Do any of the above solutions allow you to create tables and fields and on another server by matching tables and fields on your desktop automatically?
Bruce
p.s. thanks for the input
|
|
|
|
Walter Kempees
|
| Posted: 12/22/2005, 8:13 AM |
|
Bruce
MySQL Front itself has tools in it's menu to synchronize, backup databases
between tweo databases.
From Connection choose the source database.
In the Menu (top of screen) choose Extra
Options are (besides a lot of other)
Transfer and Synchronize.
Read the online help though before using to avoid copying the wrong way.
MySQL Front registered version 3.2 build 10.4
Walter
"brucewin" <brucewin@forum.codecharge> schreef in bericht
news:243aaa46937b13@news.codecharge.com...
> Do any of the above solutions allow you to create tables and fields and on
> another server by matching tables and fields on your desktop
> automatically?
>
> Bruce
>
> p.s. thanks for the input
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Walter Kempees
|
| Posted: 12/22/2005, 8:31 AM |
|
Afterthought:
This will work straigth away if your server (hosts) database has external
access.
If not you need to read the Help on PhPTunneling.
Another way to accomplish this would be to export your source databse to SQL
and reload the SQL on your target database.
Using MySQLFront on the target and any tool supplied by the Host (or
uploaded) s.a PhPMyAdmin.
|
|
|
|
brucewin
Posts: 143
|
| Posted: 12/25/2005, 6:38 AM |
|
Thanks for the help.
Still looking for an easier solution. e.g. pick all the tables on my desktop server that I need, point to another server, then duplicate tables on that server.
Bruce
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/25/2005, 2:04 PM |
|
Bruce,
Maybe you should clarify if you'd like change the database structure on the 2nd server (your 1st question), or copy/duplicate the database structure to the 2nd server (your last question).
Regarding your last question, SQLYog mentioned by fotrane does exactly that: duplicates (copies) tables between any 2 servers.
I didn't answer your 1st question because I don't know products that can easily change the database structure on another server to match your desktop server, without touching the data. I'm not sure now if that's what you're looking for.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
brucewin
Posts: 143
|
| Posted: 12/26/2005, 1:47 PM |
|
Thanks, I'll try SQLYog. I want to duplicate all and am not worried about the data. Bruce
|
|
|
|
Walter Kempees
|
| Posted: 12/27/2005, 3:05 AM |
|
As I said earlier, MySQLFront, the one you are using, does this standard.
"brucewin" <brucewin@forum.codecharge> schreef in bericht
news:243b06503eee7d@news.codecharge.com...
> Thanks, I'll try SQLYog. I want to duplicate all and am not worried about
> the
> data. Bruce
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
