pamelax Posted September 10, 2008 Share Posted September 10, 2008 Hello, Did anyone already solve this task? How is this done best? ??? I have a webshop. The products are maintained in a local MSSQL database in the office of my customer. How do I move the products automatically from the MSSQL database to the webshop database (MySQL) at my webhoster? I’d like this to be done automatically with a script every day. Thanks for any answers! Quote Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/ Share on other sites More sharing options...
Maq Posted September 10, 2008 Share Posted September 10, 2008 First you need to set up a Cron Job. After that, assign a script to that Cron that dumps your database into an .sql file and then copies the .sql file back to the other database. Quote Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/#findComment-638548 Share on other sites More sharing options...
bobox Posted September 10, 2008 Share Posted September 10, 2008 The method that Maq explained is complicated and for free. There is also a program that can do the job, unfortunately it's not for free (but good things never are ...). SyncTables.com copies and synchronises tables in databases. MySQL, MSSQL and Access are supported. I use it in a cron job to sync my tables every day. Hope this helps! Quote Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/#findComment-638589 Share on other sites More sharing options...
Maq Posted September 10, 2008 Share Posted September 10, 2008 Nice link bobox. I will have to check this out sometime. Quote Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/#findComment-638596 Share on other sites More sharing options...
fenway Posted September 10, 2008 Share Posted September 10, 2008 What about replication? Quote Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/#findComment-638632 Share on other sites More sharing options...
crazysaint Posted September 21, 2008 Share Posted September 21, 2008 First you need to set up a Cron Job. After that, assign a script to that Cron that dumps your database into an .sql file and then copies the .sql file back to the other database. hey, am facing the same sort of problem and am sure that this might be the solution.i am a bit green on mysql and mssql so go easy on the bashing. so how do i set up a cron job and could you please try give me the script that is needed to be assigned to the cron? Quote Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/#findComment-646952 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.