Hi ,
I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access to Table B in SQL express using SSMA?
Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use the upsizing wizard of MS Access.If there is no change in schema between source and destination databases (more of upsizing) then the process is pretty straight forward , The constraint here is that the data needs to be migrated to a new schema where the column names and number of columns can vary between the source table and destination table.. I just need to migrate data only and no other objects.
Need Help!
Thanks
Mahesh
Hi Mahesh,
SSMA is a right tool for migration
http://www.microsoft.com/downloads/details.aspx?familyid=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en and refer discussion at TechNet for troubleshooting http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.sqlupsizing&cat=en_us_FB980B1A-C148-9C19-560F-548B843A67AB&lang=en&cr=us
and refer this thread too http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1033679&SiteID=1
Hemantgiri S. Goswami
No comments:
Post a Comment