>If possible, can you recommend a conversion tool that will migrate Visual FoxPro NATIVE database access command syntax to SQL compliant command syntax?
>
>I know this is improbable, but I wanted to check with the experts first. The upsizing wizard only handles the table structures to SQL Server, and creates remote views.
>
>
>Jeff
There is no such tool that I know of. What type of commands are you looking to convert?
The Upsizing Wizard will convert any triggers you have defined. We have a database structure of 150 tables with some pretty extensive RI. The triggers upsized OK although the error messages it creates for RI failures are all the same. Not very helpful. We had to change them all to make them more user-friendly.
Also, you need to check any indexes the Upsizing Wizard creates. It has a tendancy to change the field order. Since the SQLServer query optimizer compares the field order in your WHERE clauses to index field orders, queries may not be optimized properly.
HTH
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
