<< When I use this upsizing wizard will it retain this indexing or do I have to do it all manual from the sql server. >>

The Upsizing Wizard, as I recall, does create the indexes that you have specified in Visual FoxPro on the
SQL Server back-end.


<< Also is remote view and odbc the way I can access the database on backend when I get It installed. >>

Yes, remote views via ODBC work just fine. And, for the sloppier complex queries, SQL pass-through stuff
via SQLEXEC also work great. When you get back to work with the Professional version available, check
out the Help area for the Professional Reference section for Client/Server functions and the like. The
SQLEXEC function is shown there in context with the other goodies available.

Good luck!