General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only