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