Perhaps, reconsider you're layout. Even with mssql, you are not talking about an easy or cheap situation (you would need to get the advanced version of mssql I believe, which is mucho dinero x 2).
Why can't both computers be at the same location (and even run off the same machine, leaving the other machine as a pure web server, no database). Just suggestions. Beyond that, if you really want the synchronicity, go for Oracle, MSSQL won't run on suse and at least you'll be in the same general technology as what you're using currently if you select oracle. -----Original Message----- From: whiskyworld.de [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 5:08 AM To: [EMAIL PROTECTED] Subject: WG: Why I will stay with Microsoft SQL Server > Hi All, > > well, since the discussion of the benefits Mysql vs. MSSQL has i've come > across a real Problem. Even if its a little bit off-topic (but only a little > bit...) - perhaps s.b. knows a solution: > > Ok, here we are: > > I'm the webmaster of www.whiskyworld.de - an online Store that sells whisky > (over 1600 products in common) - its running now on a LAMPS system based on > SuSE 7.2 - really fine - > > last week we received a new Local Server (Dell 1500SC) - (local here in our > small Company) - so now ive got the problem: How can i hold the data on the > server (located in another part of Germany) up-to-date ? at least the thing > is that there are some Products Tables that are newer here local while some > other tables are newer on the server (orders and costumer informations) - > i've read about REPLICATION in MySQL but this is only if 1 server is always > the more up-to-date one - and i need a via versa solution - > -> new whisky is in - > local is newer than server > -> new order is in -> server is newer than local > > i thought first of a selfprogrammed PHP solution because it then could > connect via SSL - in my opinion a secure solution - or ist there a ,well, > more comfortable possibility for this problem ? > > Greetings > > Korbinian Bachl > www.whiskyworld.de > --------------------------------------------------------------------- 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