Hi, i need to know how to convert ms access database to work on sql. Any help would be appreciated.
Thank you
atasoulas 0 Newbie Poster
JorgeM 958 Problem Solver Team Colleague Featured Poster
Depends on Access and SQL. What version of Access and what version of MS SQL?
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
There are tools available to do the import for you.
atasoulas 0 Newbie Poster
im using ms acces 2005 and sql developer. im not too sure on the version i'll have to check.
ive tried to find tool, but at the moment have not had any luck, can you please advise on some?
thankyou for your replies
JorgeM 958 Problem Solver Team Colleague Featured Poster
The versions matter. For example, if you have SQL 2008 installed, there is an import/export utility you can use to easily import an access database. see: http://msdn.microsoft.com/en-us/library/ms140052.aspx
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.