FoxPro与SQL [英] FoxPro vs. SQL

问题描述

大家好，

我的公司现在使用FoxPro数据库作为界面

和数据库。对于我们的情况，我得出结论，

对于我们来说，移动到一些

排序的SQL服务器将是更好的选择。我被赋予了监督

计划的大修的任务。我对安全性和正常运行时间都很偏执，首席执行官和

也越来越多地要求公司加入互动的互联网。我希望我们的客户能够将数据提交到我们的

数据库并从中提取数据（当然只有某些数据）。我的想法

是将FP表转换为SQL服务器并为接口编写一个内部的

应用程序（或基于Web的 - 优点？我不知道）。对于

互联网方面，我的想法是拥有单独的网络数据库

（SQL），它将从Web客户端获取信息。通过内部的

界面，内部用户就可以将数据从网络数据库中提取到内部SQL。通过互联网（经过验证

当然），网络用户可以通过网络数据库提取数据，他们从内部SQL数据库中提取信息。有人会请

将这个想法与优点和缺点分开。另外，如果这是最好的路线，请告诉我如何将这个想法卖给我的老板。什么是如此

在互联网上使用SQL与FP有什么好处？内部怎么样？

安全性怎么样？成本对于b $ b首席执行官的决定将起到重要作用，除非我能以其他方式出售他。我是否应该告诉他我们现在不应该这样做并节省一些钱来做对吗？或者是什么？一些

请帮忙。谢谢。


Alex

Hello everyone,
My company uses a FoxPro database right now as an interface
and a database. For our situation, I have come to the conclusion that
it would be a better choice for us to move to an SQL server of some
sort. I have been given the task of overseeing the overhaul on the
program. I am paranoid about security and uptime, and so is the CEO and
there is more and more demand for the company to get on the interactive
internet. I''d like our clients to be able to submit data to our
database and pull data from it (only certain data of course). My idea
is to convert the FP tables to and SQL server and write an internal
application(or web-based - advantages? I dunno) for the interface. For
the internet side of things, my idea is to have seperate web database
(SQL) that will put information from web clients. Through the internal
interface, internal users would then be able to pull data from the web
database to the internal SQL. And through the internet (authenticated
of course), the web users would pull data though the web database, who
pulls information from the internal SQL database. Would someone please
tear this idea apart w/ advantages and disadvantages. Also, if this is
the best route, tell me how I can sell this idea to my boss. What''s so
good about using SQL vs. FP over the internet? What about internally?
What about security? Cost is going to place a big role on the what the
CEO decides, unless I can sell him otherwise. Should I tell him that we
shouldn''t do it now and save some money to do it right? Or what? Some
help please. Thanks.

Alex

推荐答案

Alex S写道：

Alex S wrote:

大家好，

我的公司现在使用FoxPro数据库作为接口

和数据库。对于我们的情况，我得出结论，

对于我们来说，移动到一些

排序的SQL服务器将是更好的选择。我被赋予了监督

计划的大修的任务。我对安全性和正常运行时间都很偏执，首席执行官和

也越来越多地要求公司加入互动的互联网。我希望我们的客户能够将数据提交到我们的

数据库并从中提取数据（当然只有某些数据）。我的想法

是将FP表转换为SQL服务器并为接口编写一个内部的

应用程序（或基于Web的 - 优点？我不知道）。对于

互联网方面，我的想法是拥有单独的网络数据库

（SQL），它将从Web客户端获取信息。通过内部的

界面，内部用户就可以将数据从网络数据库中提取到内部SQL。通过互联网（经过验证

当然），网络用户可以通过网络数据库提取数据，他们从内部SQL数据库中提取信息。有人会请

将这个想法与优点和缺点分开。另外，如果这是最好的路线，请告诉我如何将这个想法卖给我的老板。什么是如此

在互联网上使用SQL与FP有什么好处？内部怎么样？

安全性怎么样？成本对于b $ b首席执行官的决定将起到重要作用，除非我能以其他方式出售他。我是否应该告诉他我们现在不应该这样做并节省一些钱来做对吗？或者是什么？一些

请帮忙。谢谢。

Hello everyone,
My company uses a FoxPro database right now as an interface
and a database. For our situation, I have come to the conclusion that
it would be a better choice for us to move to an SQL server of some
sort. I have been given the task of overseeing the overhaul on the
program. I am paranoid about security and uptime, and so is the CEO and
there is more and more demand for the company to get on the interactive
internet. I''d like our clients to be able to submit data to our
database and pull data from it (only certain data of course). My idea
is to convert the FP tables to and SQL server and write an internal
application(or web-based - advantages? I dunno) for the interface. For
the internet side of things, my idea is to have seperate web database
(SQL) that will put information from web clients. Through the internal
interface, internal users would then be able to pull data from the web
database to the internal SQL. And through the internet (authenticated
of course), the web users would pull data though the web database, who
pulls information from the internal SQL database. Would someone please
tear this idea apart w/ advantages and disadvantages. Also, if this is
the best route, tell me how I can sell this idea to my boss. What''s so
good about using SQL vs. FP over the internet? What about internally?
What about security? Cost is going to place a big role on the what the
CEO decides, unless I can sell him otherwise. Should I tell him that we
shouldn''t do it now and save some money to do it right? Or what? Some
help please. Thanks.

请阅读 http://www.catb.org/~esr/faqs/smart-questions.html

我认为你可能违反了所有规则这本书。很难说

因为我无法阅读上面那么大量的文本

。请阅读有关交叉发布的信息。


Lionel。

Please read http://www.catb.org/~esr/faqs/smart-questions.html

I think you may have broken every rule in the book. It''s hard to say
because there is no way I''m going to read that massive chunk of text
above. Please read about cross posting.

Lionel.

Lionel< li ****** @ gmail.comwrote：

Lionel <li******@gmail.comwrote:

> Alex S写道：

>Alex S wrote:

>大家好，
我公司使用一个FoxPro数据库现在作为一个接口和一个数据库。对于我们的情况，我得出的结论是，对于我们来说，移动到某种类型的SQL服务器将是更好的选择。我被赋予了监督
计划的大修的任务。我对安全性和正常运行时间都很偏执，首席执行官也是如此。
公司对互联网的需求越来越大。我希望我们的客户能够将数据提交到我们的数据库并从中提取数据（当然只有某些数据）。我的想法是将FP表转换为SQL服务器并为接口编写内部
应用程序（或基于Web的 - 优点？我不知道）。对于互联网方面的事情，我的想法是拥有单独的网络数据库（SQL），它将从Web客户端获取信息。通过内部界面，内部用户可以将数据从Web数据库提取到内部SQL。通过互联网（当然是经过身份验证），网络用户可以通过网络数据库提取数据，网络数据库从内部SQL数据库中提取信息。请有人将这个想法与优点和缺点分开。另外，如果这是最好的路线，请告诉我如何将这个想法卖给我的老板。在互联网上使用SQL与FP有什么关系？内部怎么样？
安全性怎么样？成本将对首席执行官决定的内容起到重要作用，除非我能以其他方式出售他。我应该告诉他我们现在不应该这样做并节省一些钱来做对吗？或者是什么？有些请帮忙。谢谢。

>Hello everyone,
My company uses a FoxPro database right now as an interface
and a database. For our situation, I have come to the conclusion that
it would be a better choice for us to move to an SQL server of some
sort. I have been given the task of overseeing the overhaul on the
program. I am paranoid about security and uptime, and so is the CEO and
there is more and more demand for the company to get on the interactive
internet. I''d like our clients to be able to submit data to our
database and pull data from it (only certain data of course). My idea
is to convert the FP tables to and SQL server and write an internal
application(or web-based - advantages? I dunno) for the interface. For
the internet side of things, my idea is to have seperate web database
(SQL) that will put information from web clients. Through the internal
interface, internal users would then be able to pull data from the web
database to the internal SQL. And through the internet (authenticated
of course), the web users would pull data though the web database, who
pulls information from the internal SQL database. Would someone please
tear this idea apart w/ advantages and disadvantages. Also, if this is
the best route, tell me how I can sell this idea to my boss. What''s so
good about using SQL vs. FP over the internet? What about internally?
What about security? Cost is going to place a big role on the what the
CEO decides, unless I can sell him otherwise. Should I tell him that we
shouldn''t do it now and save some money to do it right? Or what? Some
help please. Thanks.

>请阅读 http://www.catb.org/~esr/faqs/smart-questions.html

我想你可能打破了书中的每一条规则。很难说
因为我无法阅读上面那么大块的文字。请阅读交叉发布。

>Please read http://www.catb.org/~esr/faqs/smart-questions.html

I think you may have broken every rule in the book. It''s hard to say
because there is no way I''m going to read that massive chunk of text
above. Please read about cross posting.

如果没有，他已经打了很多。


作为FoxPro程序员，让我补充说他做了不要发布到
FoxPro组。根据版本，他可以将他的

表移动到另一个DBMS，获得DBMS安全性的好处，并且

仍然使用现有的应用程序。


此致，


Gene Wirchenko


Computerese不规则动词共轭：

我有偏好。

你有偏见。

他/她有偏见。

If not, he has hit a lot of them.

As a FoxPro programmer, let me add that he did not post to a
FoxPro group either. Depending on version, he may be able to move his
tables to another DBMS, get the benefit of that DBMS''s security, and
still use the existing app.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

" Alex S" < as ****** @ gmail.comwrote in message

news：11 ********************** @ m7g2000cwm .googlegro ups.com ...

"Alex S" <as******@gmail.comwrote in message
news:11**********************@m7g2000cwm.googlegro ups.com...

大家好，

我的公司现在使用FoxPro数据库作为接口

Hello everyone,
My company uses a FoxPro database right now as an interface

Google.com。


FoxPro与SQL Server。


Microsoft'的建议是＃1：
http：/ /msdn.microsoft.com/vfoxpro/pr...q/default.aspx （FoxPro是一个

开发人员工具，SQL Server是一个数据库引擎）。 />

您也可以尝试谷歌搜索将FoxPro迁移到SQL Server，FoxPro SQL

服务器安全性等。这里是另一个关于 ;为SQL构建VFP应用程序

Server"： http://www.informit.com/articles/art...?p=174330&rl=1


我不是VFP开发人员，但显然这两个人不必相互独立。事实上，MS似乎建议使用SQL Server作为后端，因为SQL Server提供了安全性，可靠性，复制和

的许多其他功能。完整的关系数据库引擎而VFP确实

没有很多这些功能。

Google.com.

"FoxPro versus SQL Server".

Microsoft''s recommendation is #1:
http://msdn.microsoft.com/vfoxpro/pr...q/default.aspx ("FoxPro is a
developer tool, SQL Server is a database engine").

You might also try Googling "Migrating FoxPro to SQL Server", "FoxPro SQL
Server Security", etc. Here''s another link about "Building VFP Apps for SQL
Server": http://www.informit.com/articles/art...?p=174330&rl=1

I''m no VFP developer, but apparently the two don''t have to be mutually
exclusive. In fact MS seems to recommend using SQL Server as a back-end for
VFP, because SQL Server provides "security, reliability, replication, and
many other features of a full relational database engine" while VFP "does
not have many of those features."

这篇关于FoxPro与SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！