import mysql dump file in sql server

does anyone have a good idea how i can easily import a mysql dump file in a
sql server 2000 enterprise edition
The dump file is 7 gig big however my MS SQL server is a DELL poweredge 4600
with 2 x 2.8 GHZ hyperthreaded XEON processors 800 gig harddisk space
and 6 gig of memory ( running on Windows 2000 advanced with PAE and AWE
extensions enabled )
hope someone has experience with this
Michel Posseth [MCP ]M. Posseth wrote:
> does anyone have a good idea how i can easily import a mysql dump
> file in a sql server 2000 enterprise edition
> The dump file is 7 gig big however my MS SQL server is a DELL
> poweredge 4600 with 2 x 2.8 GHZ hyperthreaded XEON processors
> 800 gig harddisk space and 6 gig of memory ( running on Windows 2000
> advanced with PAE and AWE extensions enabled )
> hope someone has experience with this
> Michel Posseth [MCP ]
I don't know what a dump file is, but if it's just extracted data from a
MySQL table, you can use the DTS Import/Export Wizard to import the
results into SQL Server.
David Gugick
Imceda Software
www.imceda.com|||MySQL dump file is proprietary and SQLServer wouldn't know what to do with
it. You will need to load the dump file into a MySQL somewhere and then
follow this whitepaper to transfer your data.
http://www.microsoft.com/technet/pr...ploy/mysql.mspx
-oj
"M. Posseth" <michelp@.nohausystems.nl> wrote in message
news:ctr4r3$di0$1@.reader13.wxs.nl...
> does anyone have a good idea how i can easily import a mysql dump file in
> a
> sql server 2000 enterprise edition
> The dump file is 7 gig big however my MS SQL server is a DELL poweredge
> 4600
> with 2 x 2.8 GHZ hyperthreaded XEON processors 800 gig harddisk space
> and 6 gig of memory ( running on Windows 2000 advanced with PAE and AWE
> extensions enabled )
> hope someone has experience with this
> Michel Posseth [MCP ]
>|||David Gugick wrote:
> M. Posseth wrote:
>
>
> I don't know what a dump file is, but if it's just extracted data from a
> MySQL table, you can use the DTS Import/Export Wizard to import the
> results into SQL Server.
>
a sql dump file is just a SQL script with DDL and data ( the same as
you can make in SQL server ) however with its own SQL dialect
so instead that it contains data from one table it contains all data
from a database
i know that it is possible to import the sql dump after changing the
dialect parameters to the corresponding mssql dialect
however we are talking about a 7 gig SQL text file
so i was just wondering if someone knows how i can unleash the power of
my MSSQL server on this mysql dump file so i can import it.
well i guess i am pioneering again ,
how the #$#$$% am i gonna loop through a 7 gig text file and find and
replace the mysql datatypes for the corresponding MSSQL datatypes .......
Michelsql

Import data from csv file

I am trying to import a csv file using the import wizard. The file is 2.5 gig and I have the entire (almost 4gig) database available. I keep getting an error that I do not have enough file space. Is the flat file size not an apple to apple match for database size? Any insite would be great! Thanks in advance.

A nnn MB or GB file imported into SQL Server won't result in an exact size increase in SQL Server. There is no one formula that will give you the exact size needed to import the file. It depends on too many variables such as data types in the table, indexes, etc. But...I would suspect it's the logging of the import if you are in full recovery and are just loading this through the wizard. Normally, you would want to import that in batches or using a bulk import/load with the space you have in the database. If you need to use the wizard and can use a query to break this up in "chucks" of data, You may want to look at importing 20 - 25 % of the records, backup the log. Import another 20 - 25% of the records, backup the log, etc. You also would want to make sure your data and log files aren't set to grow by percentages - you don't have much control over the growth of the files if you have the files set to grow in percentages.

-Sue

|||

What is the size of data file and transaction log on this 4gb database?

As explained the size of data within SQL server depends on the datatype used and number of rows.

Import data failed

I tried to import data from a SQL Server 2000 database in another machine to
my machine. The data is about 3 gig in size.
When copying the data, it failed with this error "[Microsoft][ODBC Sql
Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
SET options have incorrect settings: 'ARITHABORT'.
What does it mean and how can I fix it ?
Thank you very much.Never mind, I fixed the problem.
I was copying from a "Simple" recovery mode database to a "Full" recovery
mode database.
I change the destination database to be "Simple" and it fixed the problem.
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:%23CN2L9QBHHA.2276@.TK2MSFTNGP03.phx.gbl...
>I tried to import data from a SQL Server 2000 database in another machine
>to my machine. The data is about 3 gig in size.
> When copying the data, it failed with this error "[Microsoft][ODBC Sql
> Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
> SET options have incorrect settings: 'ARITHABORT'.
> What does it mean and how can I fix it ?
> Thank you very much.
>

Import data failed

I tried to import data from a SQL Server 2000 database in another machine to
my machine. The data is about 3 gig in size.
When copying the data, it failed with this error "[Microsoft][ODBC S
ql
Server Driver][SQL Server] UPDATE STATISTICS failed because the followin
t
SET options have incorrect settings: 'ARITHABORT'.
What does it mean and how can I fix it ?
Thank you very much.Never mind, I fixed the problem.
I was copying from a "Simple" recovery mode database to a "Full" recovery
mode database.
I change the destination database to be "Simple" and it fixed the problem.
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:%23CN2L9QBHHA.2276@.TK2MSFTNGP03.phx.gbl...
>I tried to import data from a SQL Server 2000 database in another machine
>to my machine. The data is about 3 gig in size.
> When copying the data, it failed with this error "[Microsoft][ODBC
Sql
> Server Driver][SQL Server] UPDATE STATISTICS failed because the follow
int
> SET options have incorrect settings: 'ARITHABORT'.
> What does it mean and how can I fix it ?
> Thank you very much.
>

Import data failed

I tried to import data from a SQL Server 2000 database in another machine to
my machine. The data is about 3 gig in size.
When copying the data, it failed with this error "[Microsoft][ODBC Sql
Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
SET options have incorrect settings: 'ARITHABORT'.
What does it mean and how can I fix it ?
Thank you very much.
Never mind, I fixed the problem.
I was copying from a "Simple" recovery mode database to a "Full" recovery
mode database.
I change the destination database to be "Simple" and it fixed the problem.
Thanks.
"fniles" <fniles@.pfmail.com> wrote in message
news:%23CN2L9QBHHA.2276@.TK2MSFTNGP03.phx.gbl...
>I tried to import data from a SQL Server 2000 database in another machine
>to my machine. The data is about 3 gig in size.
> When copying the data, it failed with this error "[Microsoft][ODBC Sql
> Server Driver][SQL Server] UPDATE STATISTICS failed because the followint
> SET options have incorrect settings: 'ARITHABORT'.
> What does it mean and how can I fix it ?
> Thank you very much.
>