Data Migration

  • Hi every body

    We are having different clients in different countries. We were managing one centerlized Database for all of our clients, clients were accessing the database through a web application.

    Now the clients want to have their data local in-spite of the fact that they are having no static IP.

    How is this possible to move the data from one centerlized location to different clients at different places.

    Thank you.

  • You can make use of the "Import/Export" wizard

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Thanks for the reply, but how is possible to do it through import \export wizard, I would like to remind that the destination server is having no dedicated or static IP.

    2ndly I want to automate this task so that at certain time of the day all the data of a particular clients is migrated.

    thank you.

  • First of all it is not good that there is no static IP. Atleast there would be a static server name? You may use the server name in the Import/Export wizard

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • gul_vu (7/27/2010)


    Hi every body

    We are having different clients in different countries. We were managing one centerlized Database for all of our clients, clients were accessing the database through a web application.

    Now the clients want to have their data local in-spite of the fact that they are having no static IP.

    How is this possible to move the data from one centerlized location to different clients at different places.

    Thank you.

    What does your mean 'no static IP' and how the local client server run without IP address?

    What do you want is to transfer the different client data to the different local system? or just a copy of the local data.

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

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