Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hi Matt.
>By the way... Someone here posted that Sql Server 2008 now has a Date data type. However, I'm assuming the VFP Upsizing Wizard would still convert a VFP Date column into a DateTime column, even when Upsizing to SqlServer 2008. Is that true?
The mapping between SQL Server and VFP data types are stored in a table (I don't have access to the source code right now and don't remember the name), so you can easily add a new record to it for any new data types, then choose the type you want in the grid in the wizard.
>In fact, does the Upsizing Wizard even work with Sql Server 2008 at all?
I haven't tried it but I can't see why not. It uses whatever connection information you specify, so you can point to a SQL Server 2008 DSN or specify the proper ODBC driver.
>As a matter of best practice, if you have a VFP table with a Date column, is there any reason to NOT take advantage of the new Date column in Sql Server 2008 when upsizing? Date has worked fine for me in VFP all these years, so it seems desireable to stick with Date now that it's possible.
I don't have experience with it, but I don't see why not.
Doug
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement