Tablediff command

2575069
2575069 used Ask the Experts™
on
Hi,
   By default if we use -et in tablediff it will create resultset in subscriber db only, but i want to create the resultset in someother database on source server. Is it possible?

Thanks,
c:\tablediff -sourceserver ServerA  -sourcedatabase DB1 -sourcetable Table1 
-destinationserver ServerB -destinationdatabase DB2 -destinationtable Table2 -et Tablelog

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012

Commented:
It does not look like that is possible.
Vice CEO
Commented:
Hi
I hope you fine
To get the result set in source server you can switch between source and destination like this.
thanks
diff -sourceserver ServerB  -sourcedatabase DB2 -sourcetable Table2 
-destinationserver ServerA -destinationdatabase DB1 -destinationtable Table1 -et Tablelog

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial