June 14, 2005 at 1:00 am
Hi All,
I'm converting an access 2002 database with heaps of queries in it to SQL Server. I've tried the upsizing wizard in access 2002, but it didn't move/copy the queries. I also tried to 'Import' in SQL Server but it's converting the access queriess into sql tables. Is there any other way of upgrading access queries to sql server views without manually re-creating them in SQL Server?
Thanks!
June 14, 2005 at 4:25 pm
Hello Jose,
MS Access and SQL Server have different SQL Syntax for some statements.
How many queries we are talking about?
I would use in MS ACCESS Tools ->Analyze -> Documenter
Click on Queries Tab. Click the Options Button. I would only check SQL and click OK, check queries that you need ot click Select All and click OK. Take a look at the resulting Print Preview. Click File -> Export. Select type Text Files, give extension txt. Save. Open in Notepad. Comment out with -- 3 lines per query containing query name, metadata and a word SQL. Copy to Query Analyzer and Check Syntax there
After that you may use this text to add Create View ... As words.
Yelena
Regards,Yelena Varsha
June 14, 2005 at 5:47 pm
Hi, thanks for the reply. I realize that sql and access have different syntax for sql statements. but i just need to export them somehow 'coz like i said there are heaps of queries. I'm trying the documenter right now. will keep you posted.
thanks again.
June 14, 2005 at 9:06 pm
Isn't there a collection for the queries in access just like for the forms and reports.
Like currentproject.allqueries
You could do a for each q in ... and recreate the queries on the server that way. You might have some header modofications to do but it's certainly doable (expect if the queries have parameters).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply