SQL Server Conversion
SQL Server Conversion
(OP)
We are trying to convert some of our data into SQL server. Most of our data is in free tables. We have tried using the VFP upsizing wizard but had database compatibility issues, worked with Toad SQL and tried importing in SQL Server Management Studio. Is anyone who has does this successfully willing to share any insights?
RE: SQL Server Conversion
Other than that, you may know that you can import a .csv file into an SQL table.
If you want to get the best response to a question, please check out FAQ184-2483: How to get the best response from the forum first.
RE: SQL Server Conversion
In particular, you need to think about your data types. For example, you might need to convert VFP date field to SQL Server datetimes. With integer data, you have to think about whether you want to convert to bigint, int, smallint or tinyint. And with character fields, you have to decide between char and varchar. These are all quite a crucial decisions, and not ones that can be automated.
Other decisions concern SQL Server's IDENTITY property, the use of NULLs, and the design of your indexes.
So think carefully about the design of your SQL Server data before you start worrying about the mechanics of the conversion.
I have been involved in upsizing several VFP databases to SQL Server. I have always found that the best approach is to write a custom upsizing program (in VFP). Essentially, this uses CREATE TABLE commands to create the tables in the target databases, then code using SQL Pass-through to actually move the data across. This is typically more work than using an automated tool like the VFP upsizing wizard, but it is the best option if you want to end up with a trouble-free conversion.
Of course, your scenario might be different than mine.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
RE: SQL Server Conversion
Tamar
RE: SQL Server Conversion
RE: SQL Server Conversion
You need time for the learning curve ahead. the data quantity will just determine whether you manage to do an overnight transition or not. But two weeks overall conversion time? I'd say forget it, I'd even say that no matter if it's an appliction just having a single main form and table or not. Forget it.
Bye, Olaf.
Olaf Doschke Software Engineering
https://www.doschke.name