Member Avatar for Jean Gwyneth

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...

  • 2 Contributors
  • 1 Reply
  • 118 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for buddylee17

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 .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.