Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        
            
                
                    
                        
                            
                                | Author | 
                                
                                 Topic  | 
                             
                            
                                    | 
                                         vijaygarg 
                                        Starting Member 
                                         
                                        
                                        1 Post  | 
                                        
                                        
                                            
                                            
                                             Posted - 2013-01-22 : 00:08:13
                                            
  | 
                                             
                                            
                                            | Env: SQL Server 2008 R2We have two SQL Databases used by two different applications. We need to synchronize some of data between these databases. Both the databases are in Read/Write mode and database structure may be different at source and destination. Records should be synchronized as soon as any DML statement is fired on any of the database. What are the tools/techniques available to achieve this.Thank  | 
                                             
                                         
                                     | 
                             
       
                            
                       
                          
                            
                                    | 
                                     srimami 
                                    Posting Yak  Master 
                                     
                                    
                                    160 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2013-01-29 : 03:51:32
                                          
  | 
                                         
                                        
                                          | Hi Vijay,Can you be more specific or explain more in detail?Thanks,Sridhar.  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                       
                          
                            
                                    | 
                                     visakh16 
                                    Very Important crosS Applying yaK Herder 
                                     
                                    
                                    52326 Posts  | 
                                    
                                      
                                        
                                          
                                           
                                            Posted - 2013-01-29 : 04:24:30
                                          
  | 
                                         
                                        
                                          | database structure may be different at source and destination.if above is true, how do you determine rules of synchronising?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/  | 
                                         
                                        
                                            | 
                                         
                                       
                                     | 
                                   
                            
                            
                                | 
                                    
                                      
                                     
                                    
                                 | 
                             
                         
                     | 
                 
             
         |