Article Preview
Buy Now
COLUMN
REAL SQL Server
Migrating to REAL SQL Server
Issue: 5.4 (May/June 2007)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software.
Article Description: No description available.
Article Length (in bytes): 4,552
Starting Page Number: 40
Article Number: 5414
Related Link(s): None
Excerpt of article text...
One of the benefits of using REAL SQL Server is that it gives you a pretty painless way to migrate a single-user REAL SQL Database to a multi-user REAL SQL Server database. How is this possible? If you recall from the last column, REAL SQL Server is also built on top of SQLite. In fact, it actually uses your REAL SQL Database files with no modification to get them on the server! However, you will likely have to change some of your code in order to get it to work with the server.
Migrating Existing Code
When you wrote your original code, you likely used the REALSQLDatabase class. This makes sense, since that was the database you were working with. That design decision will require you to change some of your code to make it server aware, though. We'll see in the next section how you can design your code so that it can be either single-user or multi-user.
...End of Excerpt. Please purchase the magazine to read the full article.