Convert Access Database to SQL Database
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi there, If I use SQL Server Migration Assistant for Access to convert my Access database to SQL Server Database, it adds constraints to each string type data column in my SQL database. Why is that? I've checked the string values in my Access database, and they do allow Zero Lenth values. If I add that Access database to my SQL Server Migration Assistant for Access project, and I select a Table to see the design of it, the Allow Zero Lenth flag is false. I want those characterlistics to be the same as in the Access Database. Is there a way to do that? Thanks, Werries
A programmer's life is good... or is it?? Ek dink nie so nie!