by Joel Tipke
12. November 2009 04:09
If you need to migrate an Access database to SQL this tool works. I've used it successfully on a few projects, one of them a very old Access databse.
http://www.microsoft.com/Sqlserver/2005/en/us/migration-access.aspx
The only issue I ever ran into was nvarchar(MAX) fields in a classic asp application showing up blank. The fix for this was to just go into the SQL database and set a specific size nvarchar(255) or similiar based on your actual requirements for the field. I think the driver specifed in the connection string was ancient and didn't know about a (MAX) datatype.... Just a guess though...
Subscribe