Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Access 2007 how to migrate Attachement Fields to MS SQL 2008

0 views
Skip to first unread message

Mike

unread,
Sep 25, 2009, 9:36:01 AM9/25/09
to
Hello

I am wondering if anyone has successfully migrated a ms access 2007 database
including tables with attachemts fields into ms sql 2008 database ?

I've got no idea how to do that, even after searching the internet.

all suggestions are very much welcome.

best regards mike

Mary Chipman [MSFT]

unread,
Sep 25, 2009, 1:08:27 PM9/25/09
to
Attachments were created to have parity with a Sharepoint feature and
aren't really designed for compatibility with SQL Server. You might
want to consider breaking out the attachment fields into relational
columns before you try to migrate the back end data.

--Mary

0 new messages