Migration Meta Data Storage

Hi All,
I am doing a migration from different systems to SQL Server 2005. I want to
have the mapping from source to destination mapped some where. What is the
best method of representation of these mapping?
I am now using "extendedproperties"
Thanks...ShafHi
What do you meant by "mapping from source to destination mapped some where"?
A database structure, an object structure, Login's mapping to User?
Ho do you do a migration?
"Shaf.Khalidh" <itsprobablyme@.msn.com> wrote in message
news:OGqNTomnGHA.776@.TK2MSFTNGP04.phx.gbl...
> Hi All,
> I am doing a migration from different systems to SQL Server 2005. I want
> to have the mapping from source to destination mapped some where. What is
> the best method of representation of these mapping?
> I am now using "extendedproperties"
> Thanks...Shaf
>|||Mapping of source table (foxpro, access, xls, file) column to a destination
table (sql server) column.
Just a representation which shows which source column is going to store in
the sql server table.column.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23DprnBnnGHA.1076@.TK2MSFTNGP03.phx.gbl...
> Hi
> What do you meant by "mapping from source to destination mapped some
> where"? A database structure, an object structure, Login's mapping to
> User?
> Ho do you do a migration?
>
> "Shaf.Khalidh" <itsprobablyme@.msn.com> wrote in message
> news:OGqNTomnGHA.776@.TK2MSFTNGP04.phx.gbl...
>|||Hi
Have a look at SSIS . (DTS in SQL Server 2000)
"Shaf.Khalidh" <itsprobablyme@.msn.com> wrote in message
news:udaCxPnnGHA.3532@.TK2MSFTNGP04.phx.gbl...
> Mapping of source table (foxpro, access, xls, file) column to a
> destination table (sql server) column.
> Just a representation which shows which source column is going to store in
> the sql server table.column.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23DprnBnnGHA.1076@.TK2MSFTNGP03.phx.gbl...
>