>My company has just purchased SQL 2000 and we are going to experiment with moving the data over. I have been using stonefield toolkit to create virtual fields and views. Will the toolkit work with SQL 2000? Can I move my tables with virtual fields over to SQL 2000. How about the views, can they be moved over? Will I loose a lot of features items from Foxpro 7 when migrating data over to SQL 2000?
>
>
>Thanks
>Nick Patel


You can use VFP Upsize wizard to send your data to SQL Server, but personally I would prefer DTS to upsize VFP database. Keep in mind data type’s differences between VFP and SQL Server. For example you do not have date data type instead of this DTS will create smalldatetime fields.
For views you can use our DataTools (#12963 in download section) to transfer data it works with MSDE and SQL Server.) You could make metadata using your VFP database and after that create views in SQL Server database using that metadata. Unfortunately if you have any VFP functions used in views or in stored procedures they could not work on SQL Server