Page 1 of 1
way to compare two schemas in one db? or two tables within one db?
Posted: Fri 22 Mar 2013 02:17
by bagofbirds
Hi folks,
Just downloaded the eval version. it seems i am unable to compare two schemas, only two dbs. is there no way to compare two schemas? or simply two tables within one schema?
thanks for your help.
-drew
Re: way to compare two schemas in one db? or two tables within one db?
Posted: Fri 22 Mar 2013 14:10
by alexa
You can select particular objects to compare on the 'Mapping' page of the New Data Comparison wizard.
Re: way to compare two schemas in one db? or two tables within one db?
Posted: Fri 22 Mar 2013 16:19
by bagofbirds
I should have been clearer. I dont have permissions to all schemas. Only the one i want to use. I cannot get to the mapping page as i get an error: no permissions to schema x. Can i not use this tool unless i have permissions to all schema?
Re: way to compare two schemas in one db? or two tables within one db?
Posted: Fri 22 Mar 2013 16:55
by bagofbirds
the exact error is 'permission denied for schema csat'. csat is a schema in the db that i don't have access to but that i don't need for this project. any help much appreciated.
Re: way to compare two schemas in one db? or two tables within one db?
Posted: Fri 22 Mar 2013 17:05
by alexa
Thank you for the reply.
We are currently investigating this issue and will answer you as soon as possible.