MS Access and FileMaker...

ms access database to sql server

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2008

Posts: 13

Reputation: rikunashoujo is an unknown quantity at this point

Solved Threads: 0

rikunashoujo rikunashoujo is offline

Offline

Newbie Poster

ms access database to sql server

Oct 9th, 2008

hi everyone,

I have my website which i used microsoft access as my database.
everything's working fine except when i submitted the site to my boss for approval,
they rejected it because they dont want me to use ms access as our database
because they said its not a strong database.

Now, they want me to use Sql Server instead.
my question is,
Is there a way that I can convert or upload my ms access database to an SQL server database?
I dont know anything about SQL server and so I am afraid all my pages and connections to database would be totally messed up or ruined.

I really appreciate your help...

•

Join Date: Nov 2007

Posts: 596

Reputation: buddylee17 has a spectacular aura about

Solved Threads: 125

buddylee17 buddylee17 is offline

Offline

Posting Pro

Re: ms access database to sql server

Oct 11th, 2008

•

I dont know anything about SQL server and so I am afraid all my pages and connections to database would be totally messed up or ruined.

Make a backup! (Copy, paste, rename "backup.mdb")

As far as the migration goes, use the Microsoft Upsizing Wizard or SQL Server Migration for Access .

Last edited by buddylee17; Oct 11th, 2008 at 8:05 pm.

Lost time is never found again.
- Benjamin Franklin