declare @SourceDB varchar(11) 
declare @sql varchar(128)
select @SourceDB = 'zzzzzzzz'
	create table #tables(name varchar(128))
	
	select @sql = 'insert #tables select TABLE_NAME from ' + @SourceDB + '.INFORMATION_SCHEMA.TABLES where TABLE_TYPE = ''BASE TABLE'''
	exec (@sql)
	
	create table #SpaceUsed (name varchar(128), rows varchar(11), reserved varchar(18), data varchar(18), index_size varchar(18), unused varchar(18))
	declare @name varchar(128)
	select @name = ''
	while exists (select * from #tables where name > @name)
	begin
		select @name = min(name) from #tables where name > @name
		select @sql = 'exec ' + @SourceDB + '..sp_executesql N''insert #SpaceUsed exec sp_spaceused ' + @name + ''''
		exec (@sql)
	end
	--select 'Select * From ' + name + char(10)+char(13) from #SpaceUsed where rows > 0
	select 'insert into XXX.dbo.' + name  + char(10)+ 'Select * From YYY.dbo.' + name + char(10)+char(13) from #SpaceUsed where rows > 0
	drop table #tables
	drop table #SpaceUsed

-- change to Text Results (press Ctrl+T) before running

-- change this to whichever database your selecting from
USE [YourSourceDatabase];

-- change this to the destination database name
DECLARE @targetDatabase SYSNAME = N'SomeDatabase';

SET NOCOUNT ON;

WITH    cte
          AS (
              SELECT    OBJECT_SCHEMA_NAME(p.object_id) AS ObjectSchemaName,
                        OBJECT_NAME(p.object_id) AS ObjectName,
                        p.object_id,
                        STUFF((
                               SELECT   DISTINCT
                                        N',' + QUOTENAME(c.name)
                               FROM     sys.columns c
                               WHERE    p.object_id = c.object_id
                              FOR
                               XML PATH('')
                              ), 1, 1, '') AS ColumnList,
                        SUM(p.rows) AS rows
              FROM      sys.partitions p
                        JOIN sys.tables t ON p.object_id = t.object_id
              WHERE     p.index_id IN (0, 1)
                        AND t.type_desc = 'USER_TABLE'
                        AND t.is_ms_shipped = 0
              GROUP BY  p.object_id
              HAVING    SUM(p.rows) > 0
             )
    SELECT  N'INSERT INTO ' + QUOTENAME(@targetDatabase) + N'.' + QUOTENAME(ObjectSchemaName) + N'.' + QUOTENAME(ObjectName) + N'(' + ColumnList + N')' + CHAR(13)
            + CHAR(10) + CHAR(9)+ 'SELECT ' + ColumnList + N' FROM ' + QUOTENAME(DB_NAME()) + N'.' + QUOTENAME(ObjectSchemaName) + N'.' + QUOTENAME(ObjectName)
            + ';' + CHAR(13) + CHAR(10)
    FROM    cte
    ORDER BY ObjectSchemaName,
            ObjectName;

 AND c.is_identity = 0