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 dmp into SQL Server

A newby question:

I've got a .dmp from from an Oracle database that I need to import
into SQL Server. I have no idea how to do this.

If anyone know how to do this, I'd very, very much appreciate the
help.

Thanks, CCData Transformation Services should be able to handle this just fine. You
can find it in Entreprise Manager. The wizard should walk you through all
the steps.

"ccc31807" <ccc31807@.hotmail.com> wrote in message
news:22e055d5.0408270728.66a4987c@.posting.google.c om...
> A newby question:
> I've got a .dmp from from an Oracle database that I need to import
> into SQL Server. I have no idea how to do this.
> If anyone know how to do this, I'd very, very much appreciate the
> help.
> Thanks, CC|||Hi

Output files exported from Oracle using the Oracle Export utility may
contain DDL as well as data, it will also probably contain multiple tables
and other objects. If this is your situation then I suggest that you install
Oracle onto a machine and then either create a linked server or export it in
a different way.

John
"ccc31807" <ccc31807@.hotmail.com> wrote in message
news:22e055d5.0408270728.66a4987c@.posting.google.c om...
> A newby question:
> I've got a .dmp from from an Oracle database that I need to import
> into SQL Server. I have no idea how to do this.
> If anyone know how to do this, I'd very, very much appreciate the
> help.
> Thanks, CC|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<41304103$0$25950$afc38c87@.news.easynet.co.uk>...
> Hi
> Output files exported from Oracle using the Oracle Export utility may
> contain DDL as well as data, it will also probably contain multiple tables
> and other objects. If this is your situation then I suggest that you install
> Oracle onto a machine and then either create a linked server or export it in
> a different way.
> John
> "ccc31807" <ccc31807@.hotmail.com> wrote in message
> news:22e055d5.0408270728.66a4987c@.posting.google.c om...
> > A newby question:
> > I've got a .dmp from from an Oracle database that I need to import
> > into SQL Server. I have no idea how to do this.
> > If anyone know how to do this, I'd very, very much appreciate the
> > help.
> > Thanks, CC

You may want use third party tool like FastReader form WisdomForce
(www.wisdomforce.com) to unload Oracle tables into ascii text file.
FastReader also generates input for mssql loader. One quick step
process|||ccc31807@.hotmail.com (ccc31807) wrote in message news:<22e055d5.0408270728.66a4987c@.posting.google.com>...
> A newby question:
> I've got a .dmp from from an Oracle database that I need to import
> into SQL Server. I have no idea how to do this.
> If anyone know how to do this, I'd very, very much appreciate the
> help.
> Thanks, CC

You may want to use a 3rd-party tool such as CampaignRunner for this.
You can then will port data from Oracle directly to SQL Server,
bypassing the file-based mechanisms, in just a few mouse clicks.sql