Migration VFP to MS SQL Server 2000

Dear Friends,
I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to
share the experience with you, if you have undergone such a task. Is
there any utility for achieving
this.
Any white paper or link for guidance on the same.
I wannted to migrate the whole database to MS SQL Server 2000. I wanted
to migrate the table
structures and procedures to MS SQL Server 2000.
Please shed some light please.
Regards
Kumar
--
Posted via http://dbforums.comFoxPro 7 includes an Upsizing Wizard that will move your schema and data
into SQLServer. I believe this wizard was also in 5.
However, I suggest you take the opportunity to redesign your database in SQL
rather than just rely on the Wizard. Your database will probably need design
changes to take best advantage of the SQL platform. When you have designed
your SQL schema you can use SQLServer DTS to help transform the data from
FoxPro to SQL.
Your code will certainly need re-writing. The syntax and behaviour of SQL
statements in FoxPro (SELECT, INSERT, UPDATE, DELETE) are quite different to
Transact-SQL. I don?t know of any tools to help with this process.
--
David Portas
--
Please reply only to the newsgroup
--|||In news:3561073.1068013648@.dbforums.com,
sgnerd <member23530@.dbforums.com> posted:
> Dear Friends,
> I am about to migrate a Visual FoX Pro 7.0 & 5.0 databases to MS SQL
Server 2000. I would like to share the experience with you, if you have
undergone such a task. Is there any utility for achieving this. Any white
paper or link for guidance on the same.
> I wannted to migrate the whole database to MS SQL Server 2000. I wanted to
migrate the table structures and procedures to MS SQL Server 2000.
Hi Kumar,
If you have Visual FoxPro available there's an Upsizing Wizard that will do
what you want. For more information try
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgUpsizing_Visual_FoxPro_Databases.asp .
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org, www.cindywinegarden.com