Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting/Converting VFP data to SQL Serv?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01419266
Message ID:
01419525
Views:
48
It means that you'll have to rewrite your application as well. If there're a lot of records in the table, SSIS import could be much faster.

>Thank you. However, after I posted the message I thought that bulk conversion of my VFP data to SQL is not the best idea. My VFP database does not even have a container - it comes from the old program I wrote with free tables. And more importantly the data has to be designed better. At that time I practically didn't use PK for tables; everything relies on candidate keys. So I am thinking that in this conversion from VFP to SQL Server maybe not a bad idea to manually create SQL server database correctly and then write a Update routine to move the data from VFP to SQL, making certain data changes on the fly. The application consist of only about 6 tables so it should not be such a huge task. But, hopefully, huge benefits.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform