February 9, 2004 at 12:54 pm
Hello!
Text in access is automaticly nText in SQL when I use Upsize Wizard from access. HOw can I change it to varchar instead of nvarchar? Is this an option in access or SQL?
- Thanks
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
February 10, 2004 at 5:05 am
My ritual when moving Access tables to SQL Server is to first run the import wizard in SQL Server. Then using Enterprise Manager I write the SQL for the tables. I open the SQL file, do a find replace nvarchar -> varchar, ntext -> text.
I may also change varchar(x) -> char(x) for x < 5.
Then I import the data.
Russel Loski, MCSD
Russel Loski, MCSE Business Intelligence, Data Platform
February 13, 2004 at 1:32 am
When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?
Why do you change varchar to char if varchar is larger than 5?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
February 13, 2004 at 1:32 am
When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?
Why do you change varchar to char if varchar is larger than 5?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
February 13, 2004 at 1:32 am
When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?
Why do you change varchar to char if varchar is larger than 5?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
February 13, 2004 at 1:32 am
When using the import Wizard in SQL server - you don't have any of the PK and IX transferred. At least this is what I have seen. Am I correct?
Why do you change varchar to char if varchar is larger than 5?
-Lars
Please only reply to this newsgroup. All mails would be bounced back.
February 13, 2004 at 6:29 am
Actually what I mean by x < 5 is that if the varchar is less than 5 I convert to char. My rationale for that is that a varchar takes a minimum of 4 characters even if null (it may be a larger than that). A char(3) takes three bytes of space.
Russ
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply