Hi Gowtham,
To be very honest I have never used MSSQL so I'm not really sure if
exporting tables is even possible as text files. (I assume it is.) It is not possible
to export the entire database. However rather than export table by table you could do
one thing, export the database schema and data seperately. While importing into MySQL,
import schema first then the data(while exporting the data, make sure u select all the
tables). The data will automatically go into the proper tables. I usually do this to
backup my MySQL databases.
Regards,
Gaurav
--- gowthaman ramasamy <[EMAIL PROTECTED]> wrote:
>hi Gaurav
>can we export complete database (rather than each table individualy)
>from mssql and import it into MySQL ...
>gowtham
>
>
>On Wed, 2003-07-09 at 11:06, Gaurav Arora wrote:
>> One way to go about exporting the database would be to export all the
>> information, schema and data to a text file(seperately if needed) and then
>> importing it in MySQL. MySQL has such an option, not sure about MSSQL though.
>>
>
>
>
>
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: Parasoft
>Error proof Web apps, automate testing & more.
>Download & eval WebKing and get a free book.
>www.parasoft.com/bulletproofapps
>_______________________________________________
>linux-india-help mailing list
>[EMAIL PROTECTED]
>https://lists.sourceforge.net/lists/listinfo/linux-india-help
_____________________________________________________________
Thank you for choosing LinuxQuestions.
http://www.linuxquestions.org
-------------------------------------------------------
This SF.Net email sponsored by: Parasoft
Error proof Web apps, automate testing & more.
Download & eval WebKing and get a free book.
www.parasoft.com/bulletproofapps
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
