Discussion:
Newbie Foxpro question re: Views
(too old to reply)
SQLScott
2005-02-28 19:35:05 UTC
Permalink
Why is it that when i run the Foxpro upsizing wizrd to SQL Server that my
Visual FoxPro views are export to SQL Server as Tables?

I'm not a FoxPro guy by any stretch of the imagination but aren't Foxpro
views similar to SQL Server views?

The SQL Server DTS wizard also imports them as tables, so no matter which
way i go, my FoxPro views become SQL Server tables. Is this by design?
--
Thanks,

Scott
Anders Altberg
2005-03-02 01:36:01 UTC
Permalink
Most likely you'll not want them as views in SQL Server either, except
possibly for reporting purposes. For updating, inserting and viewing you'll
just want to change your local views to remote views, that's to say point to
view to a different database by way of a remote connection.
-Anders
Post by SQLScott
Why is it that when i run the Foxpro upsizing wizrd to SQL Server that my
Visual FoxPro views are export to SQL Server as Tables?
I'm not a FoxPro guy by any stretch of the imagination but aren't Foxpro
views similar to SQL Server views?
The SQL Server DTS wizard also imports them as tables, so no matter which
way i go, my FoxPro views become SQL Server tables. Is this by design?
--
Thanks,
Scott
Loading...