>All of us are familiar with the utility kevin has given us to create local views for a new MM project. But what if you intend to develop the project against SQL Server? What I do is simply upsize the database. The problem is the upsize wizard redirects the views and renames them incorrectly. To make matters worse some of the views don't function.
>
>I don't use the redirect views option. Instead, I created a remote version of Kevin's program: remote_views.prg. To use it, create a connection to your SQL source in the database, replace all instances of "connect1" with the name of the connection you defined, issue SET PROC TO remote_views, and then DO createviews. Lickety split your remote views are created and ready to rock and roll.

Hey James,

Thanks, you just saved me a few hours worth of work! I needed to create the remote views for security and I remembered seeing this post last month.

Kind Regards,

Mat