May 13, 2014 at 8:12 am
Is there an easy way to convert Access Queries to SQL Views without doing it manually?
I have used the Databse tool to migrate tables, but cannot see to find something similiar for queries.
May 13, 2014 at 8:16 am
Meatloaf (5/13/2014)
Is there an easy way to convert Access Queries to SQL Views without doing it manually?I have used the Databse tool to migrate tables, but cannot see to find something similiar for queries.
I don't know of anything to automate converting an Access query to a view. I am not sure I would like an automated tool for this anyway. The two engines are different enough that you should look at each query when it is being converted to sql server. Of course not every query from Access could be converted to a view, more likely a stored procedure. Many of the queries (even the select ones) in Access have parameters or form values embedded in them.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 13, 2014 at 8:34 am
Thank you!
May 13, 2014 at 10:59 am
Also, be cautious using views in SQL Server. They're a fine way to obfuscate queries and implement security and other functionality. But, people start treating them like tables and joining one view to another or nesting a view within a view. That creates major performance problems.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply