[AccessD] Upsize wizard => Queries

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





More information about the AccessD mailing list