Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Migrate column descriptions from Access using SSMA

Author  Topic 

Dbar
Starting Member

12 Posts

Posted - 2008-12-13 : 10:42:16
I successfully migrated tables from an Access 2003 database into SQL Server 2005. However, the column descriptions from Access did NOT transfer.

Is there any way to transfer/migrate column descriptions from Access tables into the "description" property for columns in SQL Server?

Thanks!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-13 : 12:16:33
How did you migrate?
Go to Top of Page

Dbar
Starting Member

12 Posts

Posted - 2008-12-14 : 08:14:16
I used SSMA (SQL Server Migration Assistant for Access
Go to Top of Page

shunu87
Starting Member

1 Post

Posted - 2009-09-17 : 02:49:06
Hi I am trying to migrate Access 2003 to SQL server 2005 using SSMA..can i use SQL server 2005 express edition for this purpose?
Go to Top of Page
   

- Advertisement -