Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Export DB Structure

Author  Topic 

xpandre
Posting Yak Master

212 Posts

Posted - 2009-03-13 : 03:12:27
Hi,

Do we have something similar to the EXP function in Oracle, which can create a dump of the database structure (tables, procs, etc) without data?
I have tried the generate script thing from EM, but that takes ages!!

Thanks
Sam

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-13 : 03:40:43
try to generate script portionally - tables, sps, views etc.
Generate script has always been the only way for me to dump the db schema. alternatively you can resort to third party tools such as toad.

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com
Go to Top of Page
   

- Advertisement -