|
Home > Archive > FoxPro database connector > April 2005 > Newbie Foxpro question re: Views
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Newbie Foxpro question re: Views
|
|
| SQLScott 2005-04-07, 8:05 pm |
| 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-04-07, 8:05 pm |
| 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
"SQLScott" < SQLScott@discussions
.microsoft.com> wrote in message
news:4BE55A2F-A876-45D1-AF32- 932E4A36A8CD@microso
ft.com...
> 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
|
|
|
|
|