Creating a new database from an existing Access one

  • I have been experience difficulty converting an access DB to one that can be viewed in SQL Server 2012. This task should be simple right? However when it prompts me to select a server for the new DB to be hosted on, all the options are other PC's within my office. Is there a way that I can create a server instance so that my machine will show up? Or does anyone have a suggestion for a local server to host the database on? OR have I been going about this the complete wrong way and there is a much easier solution?

    THANKS

  • brian.stewart 98697 (7/17/2012)


    I have been experience difficulty converting an access DB to one that can be viewed in SQL Server 2012. This task should be simple right? However when it prompts me to select a server for the new DB to be hosted on, all the options are other PC's within my office. Is there a way that I can create a server instance so that my machine will show up? Or does anyone have a suggestion for a local server to host the database on? OR have I been going about this the complete wrong way and there is a much easier solution?

    THANKS

    When what prompts you? What tool are you using to help you migrate?

    Do you have a SQL Server 2012 instance stood up to accept the migrated Access database?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply