converting ms access database to sql server database?

Posted by Anilkumar431 under Sql Server on 12/28/2012 | Points: 10 | Views : 3107 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi all,
i have one database file which is of ms access database(.mdb) . that i need to convert to sql server 2008 database(.mdf)...
please help me..

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Shipramaurya on: 12/28/2012 [Member] Starter | Points: 25

0	Hi @anil Kumar, If you are using MS Access 2007 then you have this option available to move data from MDB database to Sql Server Database file.. 1. Open your database (.mdb) in MS Access 2007 2. GO to Database tools tab 3. Click Sql Server.. 4. A wizard will open That will guide you about the appropriate steps to perform.. @Shipra - S.M. Techie Anilkumar431, if this helps please login to Mark As Answer. \| Alert Moderator

Hi @anil Kumar,

If you are using MS Access 2007 then you have this option available to move data from MDB database to Sql Server Database file..

1. Open your database (.mdb) in MS Access 2007
2. GO to Database tools tab
3. Click Sql Server..
4. A wizard will open That will guide you about the appropriate steps to perform..

@Shipra - S.M. Techie

Anilkumar431, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...