SQL database schema diff tool
 
            
            
            
            
                11 Jul
                
                    2015
                
            
            
                11 Jul
                
                '15
                
            
            
            
        
    
                1:54 p.m.
            
        Hi, list! I wish I have a tool which would compare two database sachemas, where each schema is represented as a list of 'CREATE smth' instructions. The result of such a comparison would be a list of 'ALTER smth' instructions. This instruction set would change the database from first state to second, if the transition is possible without data losses. The 'hard' mode - to prepare the transition for any inputs, with minimal data losses. The database of interest is PostgreSQL. Does such a tool exist? If not, which package do I better use to build the AST of initial schemas? The example schema is in attach. Thanks in advance, Sergey
        3765
        
      
          Age (days ago)
        
      
        3765
        
    
          Last active (days ago)
        
        
        
        0 comments
    
    
        
        1 participants
    
    
    
    
    
    
    
    
    participants (1)
- 
                 Sergey Mironov Sergey Mironov