zigzagdna_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
dba_at_nospam.peasland.net
http://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 from http://www.teranews.com
Received on Mon Aug 27 2007 - 09:20:09 CDT