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! 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. 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! 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. 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? 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? Link to comment https://forums.phpfreaks.com/topic/123656-copy-or-sync-databases/#findComment-646952 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.