[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
it's chalk and cheese. with the MS SQL Server DataServer, you have ONE database - the one managed by the MS SQL Server software. There is one copy of the data. When your 4GL code executes, you are manipulating the data in your MS SQL database. Your 4GL code does not have to use all the data in the database and non 4GL application can also manipulate data in that same database. Your 4GL application will see changes made directly to the MS SQL database by other applications. with Pro2SQL, you have an OpenEdge database which is used by one or more 4GL applications. The Pro2SQL product allows you to replicate selected changes from the OE database into another separate database managed by Microsft SQL Server. So there are two copies of whatever data is being replicated by Pro2SQL - one in the OE database and one in the MS SQL database. Changes made to the MS SQL datbase by other applications are NOT replicated back into the OE database and NOT visible to the 4GL applications.

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