【复制数据库】转移业务数据

Declare UTab Cursor for
  Select Name from sys.sysobjects Where type = 'U'
Declare @TableName Varchar(200)
Declare @SQL Varchar(200)

OPEN UTab
FETCH NEXT FROM UTab INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
  Set @SQL = 'Select * Into 目标数据库.dbo.' + @TableName + ' from ' + @TableName
  Exec(@SQL)
  FETCH NEXT FROM UTab INTO @TableName
END

CLOSE UTab
DEALLOCATE UTab