[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Schema Maintenance in SQL Server (Comparing "Pro2SQL" vs. "SQL DataServer" products)

Status
Not open for further replies.
G

gus bjorklund

Guest
> On Dec 13, 2019, at 11:47 AM, dbeavon wrote: > > What about the schema holder? This is a factor on *both* of the products and involves similar management effort, right? with pro2SQL there are three schemae to maintain - the OpenEdge database definitions, the MS SQL Server definitions, and the schema holder that maps between the two. and then the pro2SQL configuration data that defines what is replicated and where it goes. schema information is in 4 places. with the DataServer, there is one set of database definitions in the MS SQL Server database and then the schema holder that defines what tables and fields are visible to the 4GL. schema information is in 2 places. so i would say with the data server there is /less/ work to schema maintenance. but a lot depends on how much and what you change after the initial setup.

Continue reading...
 
Status
Not open for further replies.
Top