Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 19 in printed book and digital formats -- plus a one-year subscription (beginning with 20.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview

Buy Now

Issue 5.4



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.