DB schema synchronization tools

Posts   
 
    
Chad2
User
Posts: 8
Joined: 19-Mar-2007
# Posted on: 24-May-2007 23:39:19   

Hi guys,

Any suggestions on tools that would synchronize schemas from Sql Server to Access without the need for modifications when using the project converter to generate the DBSpecific layers? Also later we'll want to synchronize to Firebird, Postgresql and Oracle schemas.

Thanks in advance simple_smile

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 25-May-2007 10:55:44   

We have DDL templates available (not for access though), in the customer area, so you can generate DDL SQL after you've converted the project to oracle for example, then use that DDL output to create the db on oracle simple_smile

Frans Bouma | Lead developer LLBLGen Pro
tangent
User
Posts: 41
Joined: 30-Apr-2006
# Posted on: 25-May-2007 20:11:40   

EMS (www.sqlmanager.net) makes some good tools along these lines, I use them to sync data and schema between postgres, mssql, firebird..