Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Equivalent of Oracle's export/import in sql server

Re: Equivalent of Oracle's export/import in sql server

From: Tony Rogerson <>
Date: Sun, 26 Aug 2007 19:12:03 +0100
Message-ID: <fasfrq$dp1$1$>

Your question was answer already here by Tibor:

But for the sake of clarity...

Open Enterprise Manager.

Click your server

Click Data Transformation Services

Right click Local Packages, New Package

From the left tool bar, under Task, select 'Copy SQL Server Objects Task', it's the icon that has two boxes with a red arrow connecting one to the other.

On the Source tab, select your source server and database

On the Destination tab select your destination server and database

On the copy tab select the objects to copy, by default 'All objects' is selected.

Click OK

Execute the package

Save the package if you want to redo the excercise.

The Options button gives you various options.

Tony Rogerson, SQL Server MVP
[Ramblings from the field from a SQL consultant]
[UK SQL User Community]

<> wrote in message

>I am an Oracle DBA learning SQL Server 2000. I used DTS as well as bcp
> to
> export/improt data. However, they work one table at a time. I want
> to
> export all
> the tables/views/stored procedure etc inside a database (i.e.,
> Northwind)
> and then drop Northwind, and then import the entire database
> Northwind.
> I looked at DTS Wizard. Is there any way to export all the
> tables/views/packages etc using one "command", is answer no?. I find
> DTS is table based, so
> it only exports schema of a table and its data. How about views? I
> want to
> export all the tables at the same time and then selectively import.
> Oracle
> lets you do that, but cannot find this in sqlserver (I do not want to
> copy the entire database from one sql server to another, only copy
> information in a file and then selectively restore from it).
> I looked at backup/restore. Backup kets you backup entire database,
> but there is no way to restore just a table from this backup.
> Really appreciate if you can point me in the right direction how to do
> this in sql server 2000.
> I posted this question in sql server forums, did not get a
> satisfactory answer, so trying in this Oracle forum.
Received on Sun Aug 26 2007 - 13:12:03 CDT

Original text of this message