Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 300 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Import data from one Axapta DB to another
rashi.kaushik
Member Posts: 52
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
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
0
Comments
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
Ciprian Dudau
Axapta Developer
Just curious - can't you just detach and attach SQL db directly?
Regards,
Harish Mohanbabu
Long way to go before I sleep..
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
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
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
Long way to go before I sleep..
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 ???
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