>Hi Charles.
>
>>Have all the views in another DB with no tables (as one should <g> ) so haven't found any way to work Sedna Upsizer magic on them. Suggestions?
>
>I thought the Upsizing Wizard supported that but apparently not -- it handles views but expects the DBC contains tables as well. I haven't tried this but maybe if the DBC contained one dummy table?
>
>Doug
That was my guess too - tried that - no luck . No big deal as I wrote my own view upsizer (actually kind of analyze, do the easy ones and report what the issues are in the the ones that should be looked at and hand crafted. ) The client I am upsizing right now has a VFE app with about 1000 local views, some of which contain views of views.
I know the guid thing is pretty specific to VFE apps, at least for keys, so it probably isn't worth fiddling the upsizer. If anybody else runs into it, refer them to me and I'll share some tsql scripts that will make their life easier.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.