April 2010 - Posts

• Developing Schema Compare for Oracle (Part 5): Query Snapshots

  Posted Friday, April 30, 2010 7:56 AM | 0 Comments
  
  

  If you've emailed us about a bug you've encountered with the EAP or beta versions of Schema Compare for Oracle, we probably asked you to send us a query snapshot of your databases. Here, I explain what a query snapshot is, and how it helps us fix your Read More by Simon Cooper | 0 Comments | Comment on this post Filed Under: Oracle

• Developing Schema Compare for Oracle (Part 4): Script Configuration

  Posted Monday, April 26, 2010 6:42 AM | 1 Comments
  
  

  If you've had a chance to play around with the Schema Compare for Oracle beta, you may have come across a new screen in the synchronization wizard. This screen was designed to solve a couple of issues that, although aren't specific to Oracle, are much more of a problem than on SQL Server. Read More by Simon Cooper | 1 Comments | Comment on this post Filed Under: Oracle Attachment(s): ConfigureSync.png

• Developing Schema Compare for Oracle (Part 3): Ghost Objects

  Posted Thursday, April 22, 2010 4:21 AM | 1 Comments
  
  

  In the previous blog post, I covered how we solved the problem of dependencies between objects and between schemas. However, that isn’t the end of the issue. The dependencies algorithm I described works when you’re querying live databases and you can Read More by Simon Cooper | 1 Comments | Comment on this post Filed Under: Oracle Attachment(s): ghost objects.png

• Developing Schema Compare for Oracle (Part 2): Dependencies

  Posted Tuesday, April 20, 2010 4:49 AM | 1 Comments
  
  

  In developing Schema Compare for Oracle, one of the issues we came across was the size of the databases. As detailed in my last blog post, we had to allow schema pre-filtering due to the number of objects in a standard Oracle database. Unfortunately, Read More by Simon Cooper | 1 Comments | Comment on this post Filed Under: Oracle

• Developing Schema Compare for Oracle (Part 1)

  Posted Thursday, April 15, 2010 6:31 AM | 6 Comments
  
  

  SQL Compare is one of Red Gate's most successful SQL Server tools; it allows developers and DBAs to compare and synchronize the contents of their databases. Although similar tools exist for Oracle, they are quite noticeably lacking in the usability and Read More by Simon Cooper | 6 Comments | Comment on this post Filed Under: Oracle