On Aug 27, 10:20 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> zigzag..._at_yahoo.com wrote:
> > On Aug 25, 12:48 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> >> zigzag..._at_yahoo.com wrote:
> >>> 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.
> >> Detach the Northwind database. That will also drop the database. From
> >> there, you can copy the database's datafile(s) and transaction log
> >> file(s) anywhere you want. When you want to "restore" the contents,
> >> simply attach the database to the server in question.
>
> >> HTH,
> >> Brian
>
> >> --
> >> ===================================================================
>
> >> Brian Peasland
> >> d...@nospam.peasland.nethttp://www.peasland.net
>
> >> Remove the "nospam." from the email address to email me.
>
> >> "I can give it to you cheap, quick, and good.
> >> Now pick two out of the three" - Unknown
>
> >> --
> >> Posted via a free Usenet account fromhttp://www.teranews.com-Hide quoted text -
>
> >> - Show quoted text -
>
> > This is similar to transportable tablespaces in Oracle, not export/
> > import,
>
> Kinda. But in the end, who cares? Your requirement is to move the
> tables, indexes, stored procs, views, etc from one server to another.
> Why does your requirement say that the mechanism used has to be like
> Oracle's export and import utilities? Truth is that SQL Server does not
> have a tool like Oracle's export and import utilities. And truth is that
> Oracle does not have a tool like SQL Server's DTS. You use the tools
> available to you.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com- Hide quoted text -
>
> - Show quoted text -
I agree that in the end who cares a long that data can be transferred
from one enviornment to another.
Received on Mon Aug 27 2007 - 14:19:30 CDT
