The company I work for is MS SQL Server mad - they use it as the core for one of their software products and pretty much all of their operation is based around it - sad isn't it?! ;o) Anyway, they now want a website with online ordering etc. and of course they want it to be linked via MS-SQL to their stock ordering and accounts systems. I only code for Linux when it comes to websites (WinNT/2K is just for offices as far as I'm concerned) so I usually use PHP/Perl and MySQL. The setup will be: MS-SQL server in warehouse (stock control) MS-SQL server in office (accounts) MySQL on web server (orders) The so-called 'Technical' Director wants any orders from the website to reduce the stock levels on the DB in the warehouse, and all of this to replicate with the DB in the office. Any ideas how I can do this? I know SybaseCT and FreeTDS enables PHP to connect to MS-SQL Servers, but do they do replication? I've also heard IBM have a UNIX<->NT database linking package, but I don't know what this is called. I don't need real-time replication, probably a 15mins (or nightly?) cron job would do, or maybe even just a table containing changes to the online database that would somehow apply those changes to the offline DB's......? TIA ;o) -- Simon E. John, BA(Hons), DipM Email: [EMAIL PROTECTED] | Websites designed, Business: www.suit-u-sir.com | developed and hosted Personal: www.the-jedi.co.uk | including e-commerce --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
