September 10, 2013 at 7:06 am
I am trying to use the SSMA to migrate my tables from Access 2007 to SQL server 2012. Is there a literal step by step process to migrate my tables from start to finish that I can follow?
September 10, 2013 at 7:23 am
There are a few articles out there but I find the wizard straight forward enough. However here is few examples:
http://support.microsoft.com/kb/237980
http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp
MCITP SQL 2005, MCSA SQL 2012
September 10, 2013 at 7:29 am
Yeah I tried using the Access wizard but kept getting an error message saying: The upsizing wizard does not work with the version of Microsoft SQL Server to which your Access project is connected. So I thought I would try from the SSMA
September 10, 2013 at 7:45 am
What do you mean by SSMA? Are you referring to SQL Server Management Studio (SSMS)?
MCITP SQL 2005, MCSA SQL 2012
September 10, 2013 at 7:46 am
Also I was taking about the SQL Server Import Export Wizard in SSMS not any tools within MS Access.
MCITP SQL 2005, MCSA SQL 2012
September 10, 2013 at 8:23 am
SSMA- SQL Server Migration Assistant.
September 10, 2013 at 9:38 am
I must admit I have never used that application. But if it is just tables \ data you are importing using SSIS or Import Export wizard is as easy. As you wont be able to import some of the MS Access functionality like macros etc.
MCITP SQL 2005, MCSA SQL 2012
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply