Ask your client to use it to give you the SQL file. NOTE: the SQL stmts may be very much SQL Server specific though.
Paul DuBois wrote:
At 14:24 -0600 3/11/03, kenn murrah wrote:
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?
Tell them you want a file that's in the same format that mysqldump would generate. :-)
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
-- Gopalarathnam V. Registered GNU/Linux User #300656 http://counter.li.org
--------------------------------------------------------------------- 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