CSV would be the easiest way. -Shamit Verma (http://vshamit.com) ----- Original Message ----- From: "kenn murrah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 1:54 AM Subject: what's the best format option for importing SQL Server databases?
Greetings. I've been challenged with an assignment in which my client will feed me a 9000-record SQL Server database every night, and I in turn will need to import the data into mySQL, replacing the mySQL database from the night before ... Given that scenario, and the fact that I obviously want to be able to automate the process via scripting, what is the best format for my client to send the database in? They've volunteered that the feed can be "almost any format you want" ... sooooooo, what do i want? what would be the easiest to work with? Any ideas? thanks in advance, kenn --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
