Comparing 2 databases

Using SAP's tools I have exported my SAP database and am now in the progress
of importing the exported data. This has been done as an experiment as I
have to do this in a few months time when we cluster our SAP system. When
the import has finished I will have both the original database and the new
imported database on the same SQL server (all this has been done on the same
machine). My question is this, is there a way I can compare the two
databases data wise? I understand the layout of the data will almost
certainly be different I am only concerned with data integrity.
thanks
GavPerhaps this will help you:
http://www.red-gate.com/SQL_Data_Compare.htm
Keith
"Gav" <gavin.metcalfe@.nospam.portakabin.com> wrote in message
news:cv4i78$6un$1@.newsreaderg1.core.theplanet.net...
> Using SAP's tools I have exported my SAP database and am now in the
progress
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the
same
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>|||you could also check out DB Ghost - http://www.dbghost.com
"Gav" wrote:

> Using SAP's tools I have exported my SAP database and am now in the progre
ss
> of importing the exported data. This has been done as an experiment as I
> have to do this in a few months time when we cluster our SAP system. When
> the import has finished I will have both the original database and the new
> imported database on the same SQL server (all this has been done on the sa
me
> machine). My question is this, is there a way I can compare the two
> databases data wise? I understand the layout of the data will almost
> certainly be different I am only concerned with data integrity.
> thanks
> Gav
>
>