BLOBs are very large variable binary or character data, typically documents (.txt, .doc) and pictures (.jpeg, .gif, .bmp), which can be stored in a database. In SQL Server, BLOBs can be text, ntext, or image data type.
Archive for the ‘Microsoft SQL Server’ Category
New Flex2SQL for MS SQL Server v10.x Driver Feature: LOB Support
Monday, February 16th, 2009Controlling Locking Behavior With the SET_ISOLATION_LEVEL Command
Monday, February 16th, 2009SET_ISOLATION_LEVEL controls the locking and row versioning behavior of SQL statements issued by a connection.
Preserving Recnum During Migration
Monday, February 25th, 2008The Use Regular Save During Migration (SQL Server only) means that when it is checked, SQL puts recnum in sequence on backend which meaning they won’t match the sequence from DataFlex. If the option is on, then the recnum will follow the DataFlex sequence on the backend. When this option is on, the migration takes longer. Flex2SQL contains facilities for high-speed data migration, including generating SQL*Loader scripts and text files for Oracle and bulk copying of data to MS SQL Server, making it easier to transfer very large databases with both drivers. The SQL scripts enable you to create tables and indexes outside the tool. The high-speed data migration is the default option.
How to use Triggers in With Flex2SQL Drivers
Monday, February 25th, 2008The following is a simple program which inserts records on ITEM table and the HEADER.TOTAL field is updated automatically:
Some Flex2SQL Assumptions
Monday, February 25th, 2008This is common list of assumptions we have for all drivers: