>I just tried to use the FoxPro upsize wizzard to upsize to MS-SQL 2005
>The upsize worked but it was slow and when utilizing SQL Object Explorer the data base is show as 6. compatible and will not let me expand to see any property or tables. I tried to creat the Data base first on MQL Server and creat a new data base from the wizzard but get the same effect. I have worked with SQL 2000 for years with no problems. Any Ideas?
Have you tried using SQL Server Integration Services (SSIS) in SQL Server 2005? It was called Data Transformation Services in SQL Server 2000. I don't know what the problem is with the upsizing wizard in VFP, but I had pretty good luck with DTS in SQL Server 2000.
Chris McCandless
Red Sky Software