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 from Oracle dump file

Hi,
I have an dump file for a oracle table with a ".dat" extension.
How can I import this into my SQL Server2000 db?
Mandar
I don't believe that it will be possible. I think that you will probably
have to restore the Oracle database and connect to that server via a linked
server or DTS and pull the data from the Oracle server.
Keith
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>
|||Hi,
As Keith pointed out you can not load a Oracle dump file into sql server.
FYI, a dump (backup) file from any RDBMS can not be loaded into
a different RDBMS, this is due to variations in architecture. One way is to
load the dump file into Oracle server and use DTS or use SQLLDR utility from
Oracle to
generate the text output and use BCP IN or BULK INSERT in sql server to load
it into SQL Server.
You may need to convert the SQL/PLSQL . See the below link.
http://www.microsoft.com/resources/d...rt2/c0761.mspx
Thanks
Hari
SQL Server MVP
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>

Import from Oracle dump file

Hi,
I have an dump file for a oracle table with a ".dat" extension.
How can I import this into my SQL Server2000 db?
MandarI don't believe that it will be possible. I think that you will probably
have to restore the Oracle database and connect to that server via a linked
server or DTS and pull the data from the Oracle server.
Keith
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>|||Hi,
As Keith pointed out you can not load a Oracle dump file into sql server.
FYI, a dump (backup) file from any RDBMS can not be loaded into
a different RDBMS, this is due to variations in architecture. One way is to
load the dump file into Oracle server and use DTS or use SQLLDR utility from
Oracle to
generate the text output and use BCP IN or BULK INSERT in sql server to load
it into SQL Server.
You may need to convert the SQL/PLSQL . See the below link.
0761.mspx" target="_blank">http://www.microsoft.com/resources/...r />
0761.mspx
Thanks
Hari
SQL Server MVP
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>sql

Import from Oracle dump file

Hi,
I have an dump file for a oracle table with a ".dat" extension.
How can I import this into my SQL Server2000 db?
MandarI don't believe that it will be possible. I think that you will probably
have to restore the Oracle database and connect to that server via a linked
server or DTS and pull the data from the Oracle server.
--
Keith
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>|||Hi,
As Keith pointed out you can not load a Oracle dump file into sql server.
FYI, a dump (backup) file from any RDBMS can not be loaded into
a different RDBMS, this is due to variations in architecture. One way is to
load the dump file into Oracle server and use DTS or use SQLLDR utility from
Oracle to
generate the text output and use BCP IN or BULK INSERT in sql server to load
it into SQL Server.
You may need to convert the SQL/PLSQL . See the below link.
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
Thanks
Hari
SQL Server MVP
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>

Import Dump File

Hello,
I need to import a dump file (.dmp) and create a database from that. I
cannot find the syntax in the SQL Server books online.
If anyone konws, could you please tell me the sql syntax for importing a
dump file and creating a database from it.
Thanks in advance for your help,
Steve K.
Hi
Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
restore to SQL Server 2000
RESTORE DATABASE dbname
FROM DISK = 'path and file goes here'
WITH RECOVERY
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve Kitley" wrote:

> Hello,
> I need to import a dump file (.dmp) and create a database from that. I
> cannot find the syntax in the SQL Server books online.
> If anyone konws, could you please tell me the sql syntax for importing a
> dump file and creating a database from it.
> Thanks in advance for your help,
> Steve K.
>
>
|||Thanks Mike,
I used the 'with move' command with what you said and imported the data just
fine.
Best regards,
Steve K.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BA6E1CFC-CD29-4B27-8E09-A030D072E0B7@.microsoft.com...[vbcol=seagreen]
> Hi
> Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
> restore to SQL Server 2000
> RESTORE DATABASE dbname
> FROM DISK = 'path and file goes here'
> WITH RECOVERY
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Steve Kitley" wrote:

Import Dump File

Hello,
I need to import a dump file (.dmp) and create a database from that. I
cannot find the syntax in the SQL Server books online.
If anyone konws, could you please tell me the sql syntax for importing a
dump file and creating a database from it.
Thanks in advance for your help,
Steve K.Hi
Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
restore to SQL Server 2000
RESTORE DATABASE dbname
FROM DISK = 'path and file goes here'
WITH RECOVERY
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve Kitley" wrote:

> Hello,
> I need to import a dump file (.dmp) and create a database from that. I
> cannot find the syntax in the SQL Server books online.
> If anyone konws, could you please tell me the sql syntax for importing a
> dump file and creating a database from it.
> Thanks in advance for your help,
> Steve K.
>
>|||Thanks Mike,
I used the 'with move' command with what you said and imported the data just
fine.
Best regards,
Steve K.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BA6E1CFC-CD29-4B27-8E09-A030D072E0B7@.microsoft.com...[vbcol=seagreen]
> Hi
> Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
> restore to SQL Server 2000
> RESTORE DATABASE dbname
> FROM DISK = 'path and file goes here'
> WITH RECOVERY
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Steve Kitley" wrote:
>sql

Import Dump File

Hello,
I need to import a dump file (.dmp) and create a database from that. I
cannot find the syntax in the SQL Server books online.
If anyone konws, could you please tell me the sql syntax for importing a
dump file and creating a database from it.
Thanks in advance for your help,
Steve K.Hi
Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
restore to SQL Server 2000
RESTORE DATABASE dbname
FROM DISK = 'path and file goes here'
WITH RECOVERY
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve Kitley" wrote:
> Hello,
> I need to import a dump file (.dmp) and create a database from that. I
> cannot find the syntax in the SQL Server books online.
> If anyone konws, could you please tell me the sql syntax for importing a
> dump file and creating a database from it.
> Thanks in advance for your help,
> Steve K.
>
>|||Thanks Mike,
I used the 'with move' command with what you said and imported the data just
fine.
Best regards,
Steve K.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BA6E1CFC-CD29-4B27-8E09-A030D072E0B7@.microsoft.com...
> Hi
> Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
> restore to SQL Server 2000
> RESTORE DATABASE dbname
> FROM DISK = 'path and file goes here'
> WITH RECOVERY
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Steve Kitley" wrote:
>> Hello,
>> I need to import a dump file (.dmp) and create a database from that. I
>> cannot find the syntax in the SQL Server books online.
>> If anyone konws, could you please tell me the sql syntax for importing a
>> dump file and creating a database from it.
>> Thanks in advance for your help,
>> Steve K.
>>

Import db from dump with bcp

I am trying to import a database from a dump file.
The dump file is from a sql server db.

I have created the db on another server and want to import the data from the
dump file.

I use the bcp like this :

bcp nnfdb.sa.users in x -Usa -P

nnfdb is the name of the database
users is the name of a table
x is the name of the dump file.

But I get this error :
SQLState = S0002, NativeError = 208
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'nnfdb.sa.users'.

also I am sure if I have to run the bcp for each table or if I can import
all tables in one bcp run.

Regards

KrisYou may need to specify the server in the bcp-command. As far as I know bcp works on one table for each run, so you may need to run bcp a few times.

Sometimes it's easier and more convenient to just copy the entire database from one location to another (instead of coping each table one by one).

What's the format of the dump file?|||I have also tryed this :

bcp nnfdb.sa.users in x -Usa -P -Sdk1052

dk1052 is the name of my local machine.

But I get the same error.

How could I copy the hole db in one step ?

Kris|||I now found out that if I use dbo instead of sa I dont get the same error.

So I use :

bcp nnfdb.dbo.users in x -Usa -P -Sdk1052

But it lookes like it is trying to insert everything into the users table.

The dump file is a 20G big file containing the hole db.
I havent made the dump file myself so I don't now how it was created.

Kris|||The easiest way to copy or move a database, in my opinion, is to detach the database, copy or move it to the new location, then attach it.

If the dump file does _not_ have an mdf extention I would suspect it's the result of a backup operation. You'll need to restore the file if that is the case. You can backup/restore from the EM, right click 'Databases', choose 'All tasks.. restore'
(probably restore from a device).|||I am now trying to restore the db with the EM.
But I am getting an error, see the atached file 'error1.jpg'

I have placed the db and the dump file on a drive with 80 GB

Kris|||I finally got it to work, the database was created in the wrong drive.
:)

Import db from dump with bcp

I am trying to import a database from a dump file.
The dump file is from a sql server db.
I have created the db on another server and want to import the data from the
dump file.
I use the bcp like this :
bcp nnfdb.sa.users in x -Usa -P
nnfdb is the name of the database
users is the name of a table
x is the name of the dump file.
But I get this error :
SQLState = S0002, NativeError = 208
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'nnfdb.sa.users'.
also I am sure if I have to run the bcp for each table or if I can import
all tables in one bcp run.
Regards
Kris
Sa is a login. Perhaps you meant nnfdb.dbo.users?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:963F8255-AD7F-4268-A8F3-3B5570EFCCB0@.microsoft.com...
>I am trying to import a database from a dump file.
> The dump file is from a sql server db.
> I have created the db on another server and want to import the data from the
> dump file.
> I use the bcp like this :
> bcp nnfdb.sa.users in x -Usa -P
> nnfdb is the name of the database
> users is the name of a table
> x is the name of the dump file.
> But I get this error :
> SQLState = S0002, NativeError = 208
> Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> 'nnfdb.sa.users'.
> also I am sure if I have to run the bcp for each table or if I can import
> all tables in one bcp run.
> Regards
> Kris
|||You'r right, if I use dbo instead of sa I dont get the same error.
So I use :
bcp nnfdb.dbo.users in x -Usa -P -Sdk1052
But it lookes like it is trying to insert everything into the users table.
The dump file is a 20G big file containing the hole db.
I havent made the dump file myself so I don't now how it was created.
Kris
"Tibor Karaszi" wrote:

> Sa is a login. Perhaps you meant nnfdb.dbo.users?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Kris" <Kris@.discussions.microsoft.com> wrote in message
> news:963F8255-AD7F-4268-A8F3-3B5570EFCCB0@.microsoft.com...
>
>
|||> The dump file is a 20G big file containing the hole db.
> I havent made the dump file myself so I don't now how it was created.
You need to know the format of the dump to determine the proper way to
import the data. If the file contains data from multiple tables, it may be
a SQL Server backup file rather than one created with BCP.
One method to determine if the file was created with BACKUP is by running a
Transact-SQL RESTORE FILELISTONLY from Query Analyzer:
RESTORE FILELISTONLY
FROM DISK = 'C:\MyDumps\MyFile.bkp'
Hope this helps.
Dan Guzman
SQL Server MVP
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:2111D9CB-A350-47CC-BB7C-B8C07F85D5C0@.microsoft.com...[vbcol=seagreen]
> You'r right, if I use dbo instead of sa I dont get the same error.
> So I use :
> bcp nnfdb.dbo.users in x -Usa -P -Sdk1052
> But it lookes like it is trying to insert everything into the users table.
> The dump file is a 20G big file containing the hole db.
> I havent made the dump file myself so I don't now how it was created.
> Kris
> "Tibor Karaszi" wrote:

Import db from dump with bcp

I am trying to import a database from a dump file.
The dump file is from a sql server db.
I have created the db on another server and want to import the data from the
dump file.
I use the bcp like this :
bcp nnfdb.sa.users in x -Usa -P
nnfdb is the name of the database
users is the name of a table
x is the name of the dump file.
But I get this error :
SQLState = S0002, NativeError = 208
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'nnfdb.sa.users'.
also I am sure if I have to run the bcp for each table or if I can import
all tables in one bcp run.
Regards
KrisSa is a login. Perhaps you meant nnfdb.dbo.users?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:963F8255-AD7F-4268-A8F3-3B5570EFCCB0@.microsoft.com...
>I am trying to import a database from a dump file.
> The dump file is from a sql server db.
> I have created the db on another server and want to import the data from the
> dump file.
> I use the bcp like this :
> bcp nnfdb.sa.users in x -Usa -P
> nnfdb is the name of the database
> users is the name of a table
> x is the name of the dump file.
> But I get this error :
> SQLState = S0002, NativeError = 208
> Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> 'nnfdb.sa.users'.
> also I am sure if I have to run the bcp for each table or if I can import
> all tables in one bcp run.
> Regards
> Kris|||You'r right, if I use dbo instead of sa I dont get the same error.
So I use :
bcp nnfdb.dbo.users in x -Usa -P -Sdk1052
But it lookes like it is trying to insert everything into the users table.
The dump file is a 20G big file containing the hole db.
I havent made the dump file myself so I don't now how it was created.
Kris
"Tibor Karaszi" wrote:
> Sa is a login. Perhaps you meant nnfdb.dbo.users?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Kris" <Kris@.discussions.microsoft.com> wrote in message
> news:963F8255-AD7F-4268-A8F3-3B5570EFCCB0@.microsoft.com...
> >I am trying to import a database from a dump file.
> > The dump file is from a sql server db.
> >
> > I have created the db on another server and want to import the data from the
> > dump file.
> >
> > I use the bcp like this :
> >
> > bcp nnfdb.sa.users in x -Usa -P
> >
> > nnfdb is the name of the database
> > users is the name of a table
> > x is the name of the dump file.
> >
> > But I get this error :
> > SQLState = S0002, NativeError = 208
> > Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> > 'nnfdb.sa.users'.
> >
> > also I am sure if I have to run the bcp for each table or if I can import
> > all tables in one bcp run.
> >
> > Regards
> >
> > Kris
>
>|||> The dump file is a 20G big file containing the hole db.
> I havent made the dump file myself so I don't now how it was created.
You need to know the format of the dump to determine the proper way to
import the data. If the file contains data from multiple tables, it may be
a SQL Server backup file rather than one created with BCP.
One method to determine if the file was created with BACKUP is by running a
Transact-SQL RESTORE FILELISTONLY from Query Analyzer:
RESTORE FILELISTONLY
FROM DISK = 'C:\MyDumps\MyFile.bkp'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:2111D9CB-A350-47CC-BB7C-B8C07F85D5C0@.microsoft.com...
> You'r right, if I use dbo instead of sa I dont get the same error.
> So I use :
> bcp nnfdb.dbo.users in x -Usa -P -Sdk1052
> But it lookes like it is trying to insert everything into the users table.
> The dump file is a 20G big file containing the hole db.
> I havent made the dump file myself so I don't now how it was created.
> Kris
> "Tibor Karaszi" wrote:
>> Sa is a login. Perhaps you meant nnfdb.dbo.users?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Kris" <Kris@.discussions.microsoft.com> wrote in message
>> news:963F8255-AD7F-4268-A8F3-3B5570EFCCB0@.microsoft.com...
>> >I am trying to import a database from a dump file.
>> > The dump file is from a sql server db.
>> >
>> > I have created the db on another server and want to import the data
>> > from the
>> > dump file.
>> >
>> > I use the bcp like this :
>> >
>> > bcp nnfdb.sa.users in x -Usa -P
>> >
>> > nnfdb is the name of the database
>> > users is the name of a table
>> > x is the name of the dump file.
>> >
>> > But I get this error :
>> > SQLState = S0002, NativeError = 208
>> > Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
>> > name
>> > 'nnfdb.sa.users'.
>> >
>> > also I am sure if I have to run the bcp for each table or if I can
>> > import
>> > all tables in one bcp run.
>> >
>> > Regards
>> >
>> > Kris
>>