Upsizing A Microsoft access database to SQL server requirements

Asked By Osimeon 0 points N/A Posted on - 09/22/2011

I want to  upsize the database I'm using from the original design of Microsoft Access database to SQL server model because of the expandability of my work and access cannot therefore be a good option for me, to make my database distributed and work with it in the server to client environment. 

What requirements do I need to accomplish this?

• Status: Open
• Question Views: 799
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by JPaul

Go To Solution

Best Answer

Best Answer

Answered By JPaul 0 points N/A #127696

Upsizing A Microsoft access database to SQL server requirements

Hello there!

Upsizing is the process of moving some or all database objects from an Access database to a new or existing Microsoft SQL Server database. You can use the Upsizing Wizard to upsize all databases objects from an Access database to an Access project or to upsize only data or data definitions from an Access database to a Microsoft SQL Server.

Before you start upsizing, consider backing up your database and ensure that you have adequate disk space.

The Access 2007 Upsizing Wizard is optimized to work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005.

Good Luck!

About JPaul

Questions
0

Answers
3

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/18/2011
• Question Category: MySQL Server