Upsizing Access to SQL

[darude]

Hello,
I have been searching through your forum concerning upsizing. I already upsized from Access to SQL Server 2005 using the Upsizing Wizard. And, as I have read, SQL turned most of the text data types to nvarchar. In test I changed the data types to varchar with the correct lengths and my applications aren't working properly. Can anyone suggest a method that holds the integrity of the database?

Thank you in advance, I can't find any documentation on this subject.

 

[macleod1021]

It sounds like you need to tune your queries to SQL. There's some subtle differences between the way Access and SQL treat data types.

Break out the Enterprise Manager and test your queries there (also make sure your app is expecting the right data type being returned).

If you're having trouble with a single query, then we can help fairly easy. But as far as silver bullet that will fix all of the problems, we'd just be guessing.

 

[darude]

Thank you for the response. I guess I was wondering if I need to follow another process. I did a test and changed one field from nvarchar(50) to varchar(10) and the query isn't responding properly. I wonder if I should build shells and then import that data again.