>>Why don't you get one? The SQL Server Developer Edition cost under $50.00
>>
>>>I'm using MSDE. I do not have SQL Server nor Enterprise Manager. Can you briefly tell me what DTS is?
>>>
>>>My source database is d:\c-srv\aa\hoasource.mdf and my new database base is d:\c-srv\aa\hoa_data.mdf.
>>>
>>>Can you clarify that INSERT INTO command? I would like to learn this syntax and expand on it, as I may develop a simple app for my own use in the future.
>>>
>>>Thank you for you kind assistance.
>
>Sergey,
>
>Thanks for that info. I've read about the developer edition in the past, but had no idea it was that cheap and I've just not given it enough priority, but you can bet I'll be doing it now.
>
>In the meantime, I wanted to make a test run of this update process to decide if I want to even take on this small project. And I am making that decision today.
>
>Thanks.
Elgin,
Very rough pros and cons at first glance (not to bash anyone of them):
-At first sight SQL server is a foreign land.
-Scan...endscan like constructs are not as they're in VFP and might sound harder at first (and discouraged for good reasons). Put other xBase commands in this category.
-UI on VFP side might seem to be harder to deal with.
But:
-Once you taste it ... It's addictive:) You would start to wish VFP can do everything it does.
-Speed. SQL server is like speedy Gonzales:) You might be surprised to see subsecond responses to complex queries.
Cetin