Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMA Migration Expand / Collapse
Author
Message
Posted Tuesday, September 10, 2013 7:06 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 1:56 PM
Points: 59, Visits: 120
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?
Post #1493155
Posted Tuesday, September 10, 2013 7:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 304, Visits: 573
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
Post #1493170
Posted Tuesday, September 10, 2013 7:29 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 1:56 PM
Points: 59, Visits: 120
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
Post #1493176
Posted Tuesday, September 10, 2013 7:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 304, Visits: 573
What do you mean by SSMA? Are you referring to SQL Server Management Studio (SSMS)?

MCITP SQL 2005, MCSA SQL 2012
Post #1493193
Posted Tuesday, September 10, 2013 7:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 304, Visits: 573
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
Post #1493194
Posted Tuesday, September 10, 2013 8:23 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 1:56 PM
Points: 59, Visits: 120
SSMA- SQL Server Migration Assistant.
Post #1493210
Posted Tuesday, September 10, 2013 9:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 304, Visits: 573
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
Post #1493262
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse