StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I concur with <a href="https://stackoverflow.com/questions/934869/sql-server-2005-links-to-access/937191#937191">Tony Toews</a> (and you should trust him on this, he's an Access guru): use SSMA to help you move data to SQL Server, it does a more complete job than the upsizing Wizard integrated in Access (which doesn't work for upsizing to SQL Server 2008 anyway).</p> <p>You have to be wary of a few caveat though; I've made a <a href="http://blog.nkadesign.com/2009/access-building-upsizable-applications/" rel="nofollow noreferrer">blog post</a> about some of the things you should check out.<br> The point is that if the original Access database was designed without relying too much on the liberties that Access allows (strange characters in table and column names for instance), then the process will be much easier.<br> Pay special attention to all the warning and errors reported by SSMA, they are really useful in helping you focus on the issues <em>you must</em> solve.</p> <p>With regards to performance, moving to SQL Server isn't necessarily going to make things faster.<br> In some areas it will actually be slower, sometimes much much slower:<br> Access is pretty good at optimizing certain forms of data access but once the database moves outside of its reach, it doesn't have as much control.<br> Most things will work fine though.</p> <p>You will probably have to rewrite a few queries, maybe move them as views on SQL Server instead of keeping them in your Access application.<br> Little things such as using <code>%</code> instead of <code>*</code> as wildchars in queries using <code>LIKE</code> in their <code>WHERE</code> clause can also cause strange issues like queries not returning any records.</p> <p>By the way, I'll post a very good resource Tony has on his own website regarding SQL upsizing: <a href="http://www.granite.ab.ca/access/sqlserverupsizing.htm" rel="nofollow noreferrer"><em>My random thoughts on SQL Server Upsizing from Microsoft Access</em></a>.</p> <p>There is also a good and detailed read about things to consider when using SQL Server from Access: <a href="http://msdn.microsoft.com/en-us/library/bb188204.aspx" rel="nofollow noreferrer"><em>Optimizing Microsoft Office Access Applications Linked to SQL Server</em></a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload