===========================================================
sqlserver generate ddl
===========================================================
作者: zhouwf0726(http://zhouwf0726.itpub.net)
发表于:2008.04.09 16:20
分类: SQLSERVER
出处：http://zhouwf0726.itpub.net/post/9689/459379
---------------------------------------------------------------
发表于:2008.04.09 16:20
分类: SQLSERVER
出处：http://zhouwf0726.itpub.net/post/9689/459379
---------------------------------------------------------------
sqlserver generate ddl
use master
go
declare @db_name varchar(60)
declare @cmd varchar(2000)
declare cur_db_name cursor for select name from sysdatabases where name not in ('master','tempdb','model','msdb','pubs','Northwind','dba_db')
open cur_db_name
fetch next from cur_db_name into @db_name
while @@fetch_status=0
begin
set @cmd = 'master.dbo.xp_cmdshell ' + '''"C:Program FilesMicrosoft SQL ServerMSSQLUpgradescptxfr.exe"' + ' /s updatedb /I /d '+@db_name + ' /f d:ddl_db' + substring(convert(varchar,getdate(),20),1,10) + @db_name + '.sql'''
--print @cmd
exec (@cmd)
fetch next from cur_db_name into @db_name
end
close cur_db_name
deallocate cur_db_name