Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views vs. Stored Procedures
Message
From
21/01/2011 15:22:17
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01496772
Message ID:
01496934
Views:
42
>Thanks for your replies. We are leaning towards SP's, but we want to get more opinions before we decide. We are probably going to be moving to .Net, eventually. As much as I like FoxPro (and I've been working with it for many years), I'm looking forward to using .Net, since I realize that there is less and less FoxPro being used in the businessworld.
>
>Jerry

You may find that it is faster to get an app up and running in .NET than you think vs converting VFP app that wasn't designed for SQL to sql. If your app is not already based on views rather than tables, you might want to take a look at something like Strataframe ( for Winforms ) with a very familiar design for VFP developers ( it was designed by foxpro guys ) and some really useful stuff in the DataDeploymentToolkit for keeping deployed SQL data schemas in sync with changes in the app.

Or, perhaps your existing MM app will be able to make a pretty painless transition or Kevin may have some good advice about going straight to .NET using MM .NET. It would really be worth your while to contact him since you have an MM VFP app to start with.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Reply
Map
View

Click here to load this message in the networking platform