Migrating dbf tables to SQL Server

TheMSsForum.com: The Microsoft Software Forum

I am beginning to think about migrating my free tables to SQL Server. My
idea is to use as many remote views as tables there are in the database.
This means, that if in a program I have "USE table1" I will change it now to
"USE view_table1 NODATA", and then use a REQUERY() to fetch the data of the
parametrized view. The rewrite of code I think is minimal with this
approach, and I have all the advantages of a client/server.

Or mabye it would be better not to use remote views at all and use instead
of them SQL pass-through sentences? Then at the beginning of the programm I
would make a SQLEXEC(Select....) into a local cursor. And when transaction
finishes, I would UPDATE the database from that local cursor (because there
are 1 to many relationships).

I would like to hear your comments on both approaches, since many of you
have already done this migrating process.

TiA
Walter
Top

Re: Migrating dbf tables to SQL Server by Man-wai

Man-wai
Thu Nov 02 02:24:19 CST 2006

WP wrote:
> I am beginning to think about migrating my free tables to SQL Server. My
> idea is to use as many remote views as tables there are in the database.
> This means, that if in a program I have "USE table1" I will change it now to
> "USE view_table1 NODATA", and then use a REQUERY() to fetch the data of the
> parametrized view. The rewrite of code I think is minimal with this
> approach, and I have all the advantages of a client/server.

Not responding to your question:

Why not give MySQL 5 a try? 5 supports stored procedures and
transaction. And it's basically free.

--
iTech Consulting Co., Ltd.
Website: http://www.itech.com.hk (IE only)
Tel: (852) 2325 3883 Fax: (852)2325 8288
Top

Re: Migrating dbf tables to SQL Server by tony_becky_mikey_verizon_news

tony_becky_mikey_verizon_news
Thu Nov 02 23:44:26 CST 2006

The same can be said for Express version of SQL Server, and I believe Oracle
has Oracle 10g XE that is FREE! But then you might see that Oracle 10g XE
has a built in development language (App Express version 2.1) and confuse it
with VFP... NOT!!

"Man-wai Chang" <toylet.toylet@gmail.com> wrote in message
news:uJIY%23gl$GHA.3396@TK2MSFTNGP02.phx.gbl...
> WP wrote:
>> I am beginning to think about migrating my free tables to SQL Server. My
>> idea is to use as many remote views as tables there are in the database.
>> This means, that if in a program I have "USE table1" I will change it now
>> to "USE view_table1 NODATA", and then use a REQUERY() to fetch the data
>> of the parametrized view. The rewrite of code I think is minimal with
>> this approach, and I have all the advantages of a client/server.
>
> Not responding to your question:
>
> Why not give MySQL 5 a try? 5 supports stored procedures and transaction.
> And it's basically free.
>
> --
> iTech Consulting Co., Ltd.
> Website: http://www.itech.com.hk (IE only)
> Tel: (852) 2325 3883 Fax: (852)2325 8288


Top