Home | Print | Q/A | Guest | NewsLetter
Display context of search results Case-sensitive searching
FrontPage인놈소개/2010-03-18 › 테이블스페이스사이즈계산SharedPoolSize예상 › 모든테이블에대한TableDiff명령어만들기
Database System
Data Warehouse
Data Analysis
Operating System
Open Source
Enterprise Architecture
Software Engineering
Process
Working Smart

SQL Server
PostgreSQL
Oracle
DB2
Teradata
MySQL
Performance Tuning
Programming

Link
Philosophy
Tools
Misc
Who?
_
_
SideBar Edit

Contents



create table #temp(rs varchar(8000))

declare 
	@str varchar(8000)
,	@i int

set @i = 1
set @str = 'cd "C:\Program Files\Microsoft SQL Server\90\COM"'
insert #temp values(@str)

-- =============================================
-- Declare and using a READ_ONLY cursor
-- =============================================
DECLARE cur CURSOR
READ_ONLY
FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

DECLARE @name varchar(40)
OPEN cur

FETCH NEXT FROM cur INTO @name
WHILE (@@fetch_status <> -1)
BEGIN
	IF (@@fetch_status <> -2)
	BEGIN
		if @i = 1
		begin
			set @str = 'tablediff -sourceserver "localhost\sql2000" -sourcedatabase "MuOnlineKor" -sourcetable "' + @name + '" -destinationserver "" -destinationdatabase "MuOnline" -destinationtable "' + @name + '" -q > c:\rs.txt'
			insert #temp values(@str)
		end else
		begin
			set @str = 'tablediff -sourceserver "localhost\sql2000" -sourcedatabase "MuOnlineKor" -sourcetable "' + @name + '" -destinationserver "" -destinationdatabase "MuOnline" -destinationtable "' + @name + '" -q >> c:\rs.txt '
			insert #temp values(@str)
		end
		--insert #temp exec master..xp_cmdshell @str

		set @i = @i + 1
	END
	FETCH NEXT FROM cur INTO @name
END

CLOSE cur
DEALLOCATE cur

select * from #temp
drop table #temp

EditText|Print|FindPage|DeletePage|LikePages|http://www.databaser.net|last modified 2010-03-08 17:35:30