我觉得,access相对于其他桌面型数据库,兼容sql server还是很不错的。问题不会很大。
如果要考虑以后的移植,那么应该注意不要使用access与sql server 不兼容的地方。
数据类型的兼容性基本没问题,主要考虑sql语法不一致的地方。
我给你找了点资料:
Access query syntax / SQL Server query syntax
ORDER BY in queries /ORDER BY in views not supported
DISTINCTROW/DISTINCT
String concatenation with “&”/String concatenation with “+”
TRANSFORM
(SELECT statement)
PIVOT
/
WITH ROLLUP, WITH CUBE on SELECT statements
Supported clauses/operators:
SELECT
SELECT TOP N
INTO
FROM
WHERE
GROUP BY
HAVING
UNION (ALL)
ORDER BY
WITH OWNERACCESS
/
Supported clauses/operators:
SELECT
SELECT TOP N
INTO
FROM
WHERE
GROUP BY
HAVING
UNION (ALL)
ORDER BY
COMPUTE
FOR BROWSE
OPTION
Not Supported: COMPUTE, FOR BROWSE, OPTION/Not Supported: WITH OWNERACCESS