Activity overview
Latest activity by cmille19
We've used Schema compare with PDB's for over a year without issue for hundreds of deployments. We have tns alias for each PDB. / comments
We've used Schema compare with PDB's for over a year without issue for hundreds of deployments. We have tns alias for each PDB.
Determine schema "version"
Question came up from dev's, when they look at an assembly or jar file they can tell what version release their code is at. How do they do the same for database schema. Meaning if their schema is a...
Ignore Permissions
The ignore permissions switch isn't behaving as I had envisioned, here's the scenario:
User scripts out schema objects using Schema Compare, but doesn't check the ignore permissions option so a scr...
We see that Red Gate is selecting all the columns of the table and doing an ORDER BY. The order by is what is causing the temp space issue. Two questions:
#1 Does your product have to do an ORDER BY? It seems like other data comparison products like Oracle Veridata does the sort through app. Not sure if the your SQL Server product does sorting on database also.
#2 We are comparing two 250 million rows tables in the same database, but different schemas. Does your product execute both source and target queries at same time or is it retrieving source rows first and then target? I ask because we increased temp size to large than the table, but still ran out of space. Wondering if we need space for both. / comments
We see that Red Gate is selecting all the columns of the table and doing an ORDER BY. The order by is what is causing the temp space issue. Two questions:
#1 Does your product have to do an ORDER B...
Unable to extend temp?
Getting errors comparing a table with 250 million rows. The two tables are static (not being updating during time of compare). I'm a little confused why its using temp space. I've used the SQL Serv...
Permissions Required?
Select permissions to the table to compare doesn't appear to be enough. What permissions are needed to run Oracle Data Compare?