Comments
Sort by recent activity
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.
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...