I recieved a demo of the new version of LiveCompare (2.1) recently, and during that demo, there was some functionallity which compared 2 datasources completly external to SAP.
I have a need to compare 2 SQL Server databases, which template would I use to do this?
Hi Andy,
I've written an example workflow that compares the user tables that are common to two SQL Server databases. I've tested this using sample databases on the local LiveCompare server, and it also works for databases on linked servers. Have a look at this post in the LiveCompare Templates forum.
I hope this helps.
- Howard
Andy,
In 2.1, the Execute SQL action will accept a magic new statement that you can use to define the key fields. So in your case you'll:
See the online help for a description of the new statement for defining the key fields.
Thanks Chris, that does seem to work ok now.
I am trying to actually compare the contents of several tables (quite a large list) and therefore I have another question on the same topic. This one may not be so simple but here we go. We have an application which is non-SAP based but runs on an SQL backend. Essentially the whole configuration of the application is stored in the DB spread across quite a large number of tables. The LiveCompare, style report would be a perfect way to present this comparison and tell us the difference say between our QA and DEV environments. This would, however, mean setting the datasource up for each table individually, and probably losing the benefits of automating the process.
Is it possible to change the table an external datasource uses , on the fly?
What I would like to do is take my compare tables workflow, and put it into an itterative loop so that it will work its way through a database, comparing each table as it goes. My intention was to place the tablenames in CSV format, and then read them in as an external datasource. I would then ideally like to take each name as the tablename parameter of the datasource, and kick off the compare table flow on this table (which exists in both DBs).
Howard - this is an extremely impressive example of using the new XSQL functionality to compare non-SAP data. Wow!