Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Up Size to SQL 2005
Message
 
To
04/11/2007 02:30:02
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01266503
Message ID:
01266584
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform