Robert L. Stewart
robert at webedb.com
Tue Jul 10 08:21:35 CDT 2007
The syntax for the queries is too different to be migrated. You had to do that yourself. Or, you can change your default to be SQL-92 (I think) compliant. Then you can simply copy and paste the SQL between them. But, either way, you still have to do it yourself. Robert At 07:26 AM 7/10/2007, you wrote: >Date: Tue, 10 Jul 2007 04:37:42 -0700 (PDT) >From: Sad Der <accessd666 at yahoo.com> >Subject: [AccessD] Upsize wizard => Queries >To: Acces User Group <accessd at databaseadvisors.com> >Message-ID: <460545.53873.qm at web31611.mail.mud.yahoo.com> >Content-Type: text/plain; charset=iso-8859-1 > >Hi group, > >Using the upgrade wizard I can migrate the tables and >data in a couple of minutes to SQL Server. > >(Action) Queries are not migrated. > >Does anybody know of a tool that migrates queries to >sql server views and/or sp's? > >TIA!!!! > >Regards, > >Sander