Migrating from access to sql server
I'm just in the process of migrating a database from MS Access 2000 to MS SQL Server 2000. I've installed the readiness update thing, so am no longer getting that lovely "overflow" error on the Upsizing wizard :)
However, I'm having a little difficulty with memo >> text fields. SQL Server seems to have chopped all my memo fields down to a very small "text" type field (text, (16)).
After doing a bit of research, I came across the "text in row" stored procedure that lets you increase this limit. I estimate that i need about 10,000 characters max in these memo fields - should I use "text in row" to increase the field size or should i validate all input to be under 4,000 characters so that I can use varChar?
Also, could I just check that all "text" fields in SELECT statements should appear last?
Any information/links etc appreciated,