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

Migrating accdb to sql server 2008r2 Expand / Collapse
Author
Message
Posted Thursday, March 13, 2014 4:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 2:06 AM
Points: 14, Visits: 123
Not sure if this is the right place to post. I was looking for information in regards to migrating from access database accdb to sql server 2008r2. My plan would be to create the whole back-end by script. I've never done this before so any suggestions would be appreciated.

Thanks
Post #1550607
Posted Thursday, March 13, 2014 5:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Check out the possibilities with SSIS.

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1550637
Posted Thursday, March 13, 2014 5:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 2:06 AM
Points: 14, Visits: 123
I was looking at it but haven't got a chance for a deeper dive. Will it offer me a completely scripting solution?

Thanks
Post #1550639
Posted Thursday, March 13, 2014 6:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
It will do much more than you think. Please refer SSIS in BOL for further detail.

You can also think about database import which also support Access source.

Refer following links which might be useful:

http://technet.microsoft.com/en-us/library/ms140052.aspx
http://www.sqlservercentral.com/Forums/Topic1139114-391-1.aspx

HTH



---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1550650
Posted Friday, March 14, 2014 11:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:54 AM
Points: 1,516, Visits: 2,722
Take a look at SSMA, it is not a scripting solution but makes it very easy to migrate:

Microsoft SQL Server Migration Assistant for Access v5.2
http://www.microsoft.com/en-us/download/details.aspx?id=28763

"SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server.
SSMA for Access v5.2 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Azure."

I have used this in the past to move Access into SQL and it works very well. In some cases you may find that you need to rename tables / columns if they violate MSSQL naming rules - if so then a great tool is Find & Replace from rickworld.com which costs about $40 USD.
Post #1551274
Posted Friday, March 14, 2014 12:24 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 8:37 AM
Points: 301, Visits: 1,280
Agree...Start with SSMA. I've used it in the past without any issues.
Post #1551282
Posted Friday, March 21, 2014 9:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:27 AM
Points: 418, Visits: 652
but remember that both solutions are only going to migrate the database and data, not any GUI. (please tell me that your Access application has a front-end database with the user controls and back-end database with the data..)

Post #1553577
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse