Hello,
The above solution takes a lot of time if if u have many tables..
And if u take many databases , then this process will take a lot of time.
Can u give a command or procedure, which automatically takes the backup of all the structures in the database
With regards,
winsletmathew...
winsletmathew
Last Activity: Nov 18 '08, 05:38 AM
Joined: Nov 3 '08
Location:
-
winsletmathew started a topic How to take backup of only the structure of a database in Ms-sql, no need of data.in SQL ServerHow to take backup of only the structure of a database in Ms-sql, no need of data.
I need the backup of only the structure of database, not the data.
I tried, this procedure , but it is copying the whole database
create Procedure BackupAlldataba ses
as
declare cur_databases cursor for
select name from master..sysdata bases where name not in
('tempdb','mast er','Northwind' ,'pubs','model' ,'msdb')
...
No activity results to display
Leave a comment: