Showing posts with label dump. Show all posts
Showing posts with label dump. Show all posts

Monday, March 19, 2012

how to import MySql dump file?

Dear sir,
I got a file in the format of MySlq dump .sql file. It is about 120mb.
However should I import it into my MSDE database? I have MSDE in my XP pc,
but I do have a Enterprise manager on my PC as well.
Thanks.Hi
MySQL is not a Microsoft product. You need to load your MySQL dump into a
MySQL database installation. From there, you need to BCP or export the data
to MSDE.
A direct load is not possible.
Regards
Mike
"Guoqi Zheng" wrote:

> Dear sir,
> I got a file in the format of MySlq dump .sql file. It is about 120mb.
> However should I import it into my MSDE database? I have MSDE in my XP pc
,
> but I do have a Enterprise manager on my PC as well.
> Thanks.
>
>

Friday, March 9, 2012

how to import an Oracle 8.1.7 dump file into SQL server 2000 ?

Hi,
I do not know if it can be done:
how to import an Oracle dump file into SQL server ?
That dump file contains the content of a table, excported from Oracle.
Is there a way or another to import it to SQLServer 2000 ?
ThanksHi

I think it is better to use DTS packge or use the Import/Export Wizard, but directly from an Oracle dump file i don't think so.|||Oracle Dump files are written in binary that only Oracle understands. If the table is still in Oracle, you can try linking the Oracle schema to SQL and running a DTS to bring in the data.