Convert DB

[GeorgeBC]

Hi,

I'm using SQL Server 2005 Developer Edition. I have a MS Access Database. How can I convert to SQL Server Database from my Access Database? I could not find wizard.

Thank you.

 

[ZmrAbdulla]

From Access DB You can upgrade to SQL Server.

TOOLS > DATABASE UTILITIES > UPGRADING WIZARD...

You should have Admin rights on sql server/machine

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[GeorgeBC]

I couldn't find any upgrade wizard under Tools-Database Utilities

I have this menu in msaccess.

Tools - Database Utilities - Convert database to access97 or access2000
Compact and repair database
...

Do I have any chance doing this from SQL server 2005 ?

Thank you

 

[gmmastros]

in the 2005 management studio, create a new database, then right click on it. Select Tasks, then import data, run through the wizard.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[ZmrAbdulla]

How to convert an Access database to SQL Server

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q237980

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[GeorgeBC]

Thank you for help. I have convert it my db.