Mertech BTR2SQL Tech Blog

Enhanced Support for Magic Enterprises uniPaaS Applications with BTR2SQLv5.0

helenh — Wed, 27 Feb 2013 20:54:48 +0000

The new BTR2SQL v5.0 beta version enables uniPaaS users to migrate and convert their existing data from Btrieve data files to an SQL backend by offering direct export from the application source. Converting your Btrieve data to SQL requires access to Data Definitions, usually through DDF files, which Magic applications do not normally use. In the [...]

Troubleshooting Btrieve Driver Deployment

helenh — Tue, 12 Feb 2013 20:13:59 +0000

A Windows application accessing Btrieve data uses either wbtrv32.dll or w3btrv7.dll. When you deploy your migrated application you must provide the Mertech drivers as a replacement for these two DLLs. If your application cannot locate the Mertech version of the driver or one of its dependencies, the application will not load or execute properly. Locating the Mertech [...]

INT File Template for B_CREATE

helenh — Thu, 20 Dec 2012 14:17:42 +0000

The B_CREATE syntax was expanded so your application can provide the name of a pre-existing INT file to use as a pattern when creating a new table on the SQL server. Background The original B_CREATE syntax is: B_CREATE KeyBuffer Where KeyBuffer is <filename> The only information available to the driver for creating a new file was the filename and indexes. [...]

Update MDS_RECNUM Automatically

helenh — Tue, 28 Aug 2012 16:14:54 +0000

The BTR2SQL Data Migration Utility adds the auto-increment field MDS_RECNUM as the first column of each migrated table. An extract of a migration trace is shown below: 21:51:31.078> btr2SQL.exe: Converting Billing 21:51:31.218> PrimaryKey set to recnum 21:51:32.406> SQL_FOR_SET Defined for: DemoData.dbo.BILLING 21:51:32.406> Creating new table (BILLING) at ‘c:\pvsw\demodata\billing.mkd’ 21:51:32.406> RecSize=139; 7 fields, [...]

How to run a DOS Btrieve application with a SQL server

thomaso — Wed, 19 Jan 2011 17:13:15 +0000

There are still plenty of DOS-based Btrieve applications in use today. Is it possible to move these applications to a current SQL server to take advantage of integration with other applications and powerful data management tools? The Mertech BTR2SQL driver is a replacement for the Btrieve interface. As noted in the white papers and documentation, the [...]