Access database to SQL?

PhantomKarl · 29 Jun 2006 at 08:52

How would I convert an Access database to an SQL database?

GravyMonster · 29 Jun 2006 at 09:32

In your SQL Server program group on your start menu should be something called the 'Upsizing Wizard' or something along those lines. All you have to do is follow those steps, and providing everything you've done in access is compatible with SQL, job done.

HTH.

PhantomKarl · 29 Jun 2006 at 10:02

Will have a go thanks

PhantomKarl · 29 Jun 2006 at 10:59

using mssql server and it doesn't have that option

Thrash · 29 Jun 2006 at 12:19

In Access, go to tools, database utilities then upsizing wizard.

GravyMonster · 29 Jun 2006 at 16:39

doh

Thanks thrash, i knew what the tool was called, but couldn't remember 100% where it was.

Thrash · 29 Jun 2006 at 22:48

No problem, I recently upsized an Access db to SQL Server and despite having lots of VBA at the back of it and a lot of relationships the upsizing worked with few problems.