Migrating queries in Access 2000 to SQL Server 2000 
Author Message
 Migrating queries in Access 2000 to SQL Server 2000

Hello,

I have over 500 queries to migrate is there an easier way
than one by one from Access 2000 to SQL Server 2000?

STEPS FOR EACH QUERY NOW:
I have to first copy each SQL statement from Access to
the SQL Query Analyzer for creating the view or stored
procedure.

Then, check the each query parse and execute which
completes successfully; however

After create then type
execute [ACCU_Ring OCO All By Week Details_SP]
then all the errors show up at this stage.

Now I have to reconcile each query remember over 500
before the results show up in my panel. The errors are
mostly what worked in Access may be different syntax in
SQL Server 2000.

Thanks,



Sun, 06 Nov 2005 19:53:46 GMT
 Migrating queries in Access 2000 to SQL Server 2000

if u have the script file u can copy the entire script into Query Analyzer
and Execute the script.
Do not forget to add GO command after each query


Quote:
> Hello,

> I have over 500 queries to migrate is there an easier way
> than one by one from Access 2000 to SQL Server 2000?

> STEPS FOR EACH QUERY NOW:
> I have to first copy each SQL statement from Access to
> the SQL Query Analyzer for creating the view or stored
> procedure.

> Then, check the each query parse and execute which
> completes successfully; however

> After create then type
> execute [ACCU_Ring OCO All By Week Details_SP]
> then all the errors show up at this stage.

> Now I have to reconcile each query remember over 500
> before the results show up in my panel. The errors are
> mostly what worked in Access may be different syntax in
> SQL Server 2000.

> Thanks,



Mon, 07 Nov 2005 05:40:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Migrate from Old SQL 2000 server to a New SQL 2000 server

2. Appropriate forum for Access 2000 - MS SQL Server 2000 client-server queries

3. Cannot migrate from access 2000 to SQL 2000

4. cannot migrate access 2000 to SQL 2000

5. How to import an access 2000 query into sql server 2000

6. Help : Migrating from Access 2000 to SQL Server as a Back End

7. Problem in migrating from Access 2002 to SQL server 2000

8. Migrating Access 2000 to SQL Server

9. Migrating an SQL Server 7.0 database to an SQL Server 2000

10. Migrate to Win 2000/Sql 2000 from Win Nt/Sql 7.0

11. Migrating from SQL Server 2000 to SQL Server 7

12. Migrate DTS from SQL Server 7 to SQL Server 2000


 
Powered by phpBB® Forum Software