🚀 go-pugleaf

Cecil Green wrote:

> One of my clients will be moving to MS-SQL v6.5.  If I am doing VDB 
> development offsite and _not_ connected to that database system via a WAN 
> and SQL-Links, how could I use a copy (or subset) of its tables for 
> development and testing purposes?

You would have to create a copy of those tables, which would not be in 
MS-SQL format. You should be able to use the UpdateSet object (or the 
DataPump or Data Migration Wizard or whatever we're calling it nowadays) 
to convert the data. (Or get a copy of MS-SQL to run on your develoment 
machine.)

> Could my local version of Interbase be configured to use that MS-SQL table 
> in some limited fashion

Nope, different formats.

> if the SQL queries were limited to the local-
> SQL set of commands?  I guess my question really relates to the capacity of 
> (local) Interbase to simulate the target RDBMS.

Part of the reason for going SQL-based for all table formats is that it's 
more scalable. So in theory, you could recreate the database using DBF or 
DB tables -- if the database was simple. Interbase would probably do a 
better job of mimicking your MS-SQL database because Interbase is a 
"real" RDBMS, with more complete SQL support and the bells and whistles 
like stored procedures and triggers. Of course, that stuff tends to be 
platform-dependent as well.

You yes, you may be able to use local Interbase, and you may not have to 
simplify your SQL much at all.

-- 
//Ken@Inprise
<Please follow-up to newsgroup; do not reply to email>