Post reply

Migration of data from old server to new server

  • May 17, 2012 at 8:14 am

    #261456

    Hi,

    I have a requirement,i have a code which was written in Vb.net for migration of data,so my client dont need that type of coding he wants in either SSIS package or like stored procedure

    cnnDB = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=v:\database\APM.mdb;")

    this is the connection of my old server so i have to convert the data into new server(sql server 2008)

    how to write the stored procedure for this? any one help that could me appreciated.

    Thanks!

  • May 17, 2012 at 8:27 am

    #1489053

    ...i have a code which was written in Vb.net for migration of data,so my client dont need that type of coding he wants in either SSIS package or like stored procedure

    ...

    how to write the stored procedure for this?

    ...

    By hand.

    Do you really think that information provided in your question is enough to help you with writing the stored procedure?

    I guess the way this question is asked, would only qualify for the following answer:

    You will need to hire some SSIS or SQL specialist.

    _____________________________________________
    "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]

  • May 17, 2012 at 8:29 am

    #1489055

    you are migrating data from Access to SQL server - use the ACCESSS TO SQL SERVER MIGRATION WIZARD

    MVDBA

  • May 17, 2012 at 9:08 am

    #1489092

    michael vessey (5/17/2012)

    you are migrating data from Access to SQL server - use the ACCESSS TO SQL SERVER MIGRATION WIZARD

    This is already built in. Use Micheal's advice.

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

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