Question about upsizing to SQL Server

[Mattias]

Hi

I want to upzise my db to SQL Server 2005 and have a question about
differences in datatypes.

My PM datatype fields in Access, will it be nText or nVarcharMax in SQL
Server, what is the difference between them?

Mattias

 

[Jeff Boyce]

Mattias

You didn't indicate what type the field is in Access...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mattias]

I wrote pm data type below, ( the nolimit text tadatype in Access.

Mattias

 

[Jeff Boyce]

I don't understand PM datatype. I know about Access data types of Text and
Memo.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mattias]

Swedish version of office here, they translated the Memo to pm for some reason.
So memo is the one.

Mattias

 

[Jeff Boyce]

Even after converting to SQL-Server, you can alter the data type in SQL
Server in a manner analogous to how you'd alter the data type in Access. If
it converts to a type you don't want to use, change it!

For more information on the datatypes in SQL, you can check SQL Books on
Line. I believe it's freely downloadable from Microsoft.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Gil Lapid Shafriri]

You can also try SQL Server migration for Access that let you specify type
mapping per table.

http://www.microsoft.com/sql/solutions/migration/default.mspx