[AccessD] Export query to SQL Server

So the idea is to move the tables back into a copy of the FE and upsize the
whole?

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Reid
Sent: Saturday, January 31, 2004 2:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export query to SQL Server


John

Only thos e the upsizing wiz will pick up the reszt I do manually usually
creating stored procedures. Simly cut and paste the SQL into the Query
Analyser and convert to a stored procedure.

The QA will highligh the error lines for you. Slightly different version of
SQL used.

Access 2003 does a good job reporting non upsized queries which helps speed
this up a bit. I have head of a tool called Proc Blaster. Not sure of the
URL



Martin


----- Original Message -----
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Saturday, January 31, 2004 7:00 PM
Subject: [AccessD] Export query to SQL Server


> Is there a way to export an entire query to SQL Server?  I don't want to
> have to go manually recreate my queries out there.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com