Before data can be converted to SQL Server, the DataFlex SQL Server Driver must be loaded. This is best accomplished by creating a Managed Connection for the workspace. You can also load drivers using the Configure Database Drivers option from the Tools menu in the Studio.
SQL Server has a number of rules and specifications that are different from DataFlex. In general, they are less restrictive but not in some cases. The DataFlex Specifications can be found in the DataFlex documentation, the Microsoft SQL Server specifications can be found in the SQL Server documentation.
One restriction that you should be aware of is the maximum row size (record length). The row size in SQL Server is limited to 8060 bytes. The actual data for text type and image type columns is not included in this maximum. Information about the location of that data takes up 16 bytes per text or image column in the row size.
If a DataFlex table to be converted results in a table that does not comply with SQL Server’s rules and restrictions, the table cannot be converted. You should adjust the definition of the table before you can convert it. This means you also need to adjust all DataFlex programs using this table.