Experience of converting ACCESS to SQL SERVER

1. When the automatic numbering type in the ACCESS database is converted, SQL server does not set it to the automatic numbering type,
2. For date-related fields during conversion, SQL SERVER is of the smalldatetime type by default. We 'd better change it
Datetime type, because the range of datetime type is larger than that of smalldatetime type. In this case, use
If the smalldatetime type is used, the conversion fails. If The datetime type is used, the conversion is successful.
3. The SQL statements used to operate these two databases are not all the same, for example, deleting a record for an ACCESS database
Use: "delete * from user where id = 10", and use: "delete
4. date functions are different. In the ACCESS database processing, functions such as date () and time () can be used,
In SQL SERVER database processing, only functions such as datediff and dateadd can be used, instead of date () and time ().
5. For ACCESS database processing, some VB functions can be used in SQL statements, such as the cstr () function.
SQL SERVER databases are being processed, but cannot be used.