Import data from one Axapta DB to another

rashi.kaushik
rashi.kaushik Member Posts: 52
edited 2006-04-20 in Dynamics AX
Hi

I need to import data to one axapta DB from another axapta DB without importing data in 2-3 tables..
Both databases have the same schema.

Any ideas how to do this?

Thanks in advance
Rashi

Comments

  • Mugur
    Mugur Member Posts: 93
    Hi,

    You should use the data import/export feature from Administration/Periodic. Create a new export group, set it up to exclude the tables you don't want. Then perform the export from one database (company) and import into the other.

    Hth,
    Ciprian
    Kind regards,

    Ciprian Dudau
    Axapta Developer
  • rashi.kaushik
    rashi.kaushik Member Posts: 52
    Thanks Mugur
  • Harish
    Harish Member Posts: 172
    Hi Rashi,

    Just curious - can't you just detach and attach SQL db directly?

    Regards,

    Harish Mohanbabu
    Harish Mohanbabu
    Long way to go before I sleep..
  • rashi.kaushik
    rashi.kaushik Member Posts: 52
    Hi Harish

    I am not able to understand you properly.

    But let me explain the situation i am working on.
    I have 2 databases with exactly the same schema, one is having data and the other is empty and i am running both of them with the same axapta application. Now wat i wanted is to export the data from one DB and import it in the empty DB but there are some tables in the empty DB in which i dont want any data.

    Thanks
    Rashi
  • rashi.kaushik
    rashi.kaushik Member Posts: 52
    Hi Harish

    I am not able to understand you properly.

    But let me explain the situation i am working on.
    I have 2 databases with exactly the same schema, one is having data and the other is empty and i am running both of them with the same axapta application. Now wat i wanted is to export the data from one DB and import it in the empty DB but there are some tables in the empty DB in which i dont want any data.

    Thanks
    Rashi
  • leon_der_profi
    leon_der_profi Member Posts: 1
    Hi are you using an Oracle DB oder MS SQL Server ?
  • Harish
    Harish Member Posts: 172
    Hi Rashi,

    Apologies for not being clear.

    How many tables do you want to clear? If they are not too many, then I would just attach the SQL backup DB from the first to the second system through SQL EM. And later manally delete those data that you want to delete.

    Hope this helps,

    Harish Mohanbabu
    Harish Mohanbabu
    Long way to go before I sleep..
  • vulam
    vulam Member Posts: 24
    Hi Rashi,
    you can follow Harish suggestion, however, if i was you, i probably use the DTS in SQP Server to transfer data. i found it is more flexible and easier to do this sort of thing using DTS. What you think harish ???
  • Swoop
    Swoop Member Posts: 6
    Hi Rashi,

    I agree with vulam, DTS can give you much more ease, but it doesnt work though if you are trying to trasfer data from a non-unicode DB to a unicode enable DB
    Great powers comes with great responsibility - Uncle Ben

Categories