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,
Received on Sat Aug 25 2007 - 12:40:20 CDT
