Post reply

MS access to sql server 2008

  • March 20, 2012 at 7:30 am

    #253310

    Hi,

    i have mdb files used by ActiveExperts Network monitor manager.

    I want to migrate those access files to sql server databases.

    How can i do it.

    P.S. i dont have any sql server installed on the machine.

    So, which Verison should i install and how to migrate.

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

  • March 20, 2012 at 7:45 am

    #1461620

    SKYBVI (3/20/2012)

    Hi,

    i have mdb files used by ActiveExperts Network monitor manager.

    I want to migrate those access files to sql server databases.

    How can i do it.

    P.S. i dont have any sql server installed on the machine.

    So, which Verison should i install and how to migrate.

    Regards,

    Skybvi

    Install latest version of SQL Server you have.

    Create new database.

    Then you can use import data from SSMS or create SSIS package to do so.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • March 20, 2012 at 10:50 am

    #1461773

    Eugene Elutin (3/20/2012)

    SKYBVI (3/20/2012)

    Hi,

    i have mdb files used by ActiveExperts Network monitor manager.

    I want to migrate those access files to sql server databases.

    How can i do it.

    P.S. i dont have any sql server installed on the machine.

    So, which Verison should i install and how to migrate.

    Regards,

    Skybvi

    Install latest version of SQL Server you have.

    Create new database.

    Then you can use import data from SSMS or create SSIS package to do so.

    There are 2 files :-

    stats.mdb (2 gb)

    log.mdb (250 mb)

    So, do i need to make 2 databases in sql server and then do import tasks from both files or

    just 1 database to be created and import it from stats.mdb

    IS the log.mdb the log file in sql server??

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

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

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