Equivalent of Oracle's export/import in sql server

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 Fri Aug 24 2007 - 21:32:00 CDT