Import and export to more tables data in sql server 2005

ahmedba
Member Posts: 424
Hi guys I have database have 20 table name AA and sql i have is sql server 2005 can i make
auto processes import and export by ssis to data only.because what i want to is moving data from database to another database. and this two databases not in same place and no network between two databases meaning every one work alone.
thanks
auto processes import and export by ssis to data only.because what i want to is moving data from database to another database. and this two databases not in same place and no network between two databases meaning every one work alone.
thanks
0
Comments
-
Hi,
If you are using Navision then my suggestion is to use Universal Excel Importer for this part, you can find this utility in mibuso downloadUday Mer | MS Dynamics NAV Techno-Functional Consultant0 -
If i want to export data what i do .this tool not make export to data to excel or any formate
and are this tool using to more tables
thanks0 -
Hi,
To Export simply copy paste data to excel, or if the data is large write simple select query in SQL, and export result to text.Uday Mer | MS Dynamics NAV Techno-Functional Consultant0 -
Maybe you could check out the BCP utility of SQL Server: http://msdn.microsoft.com/en-us/library/aa174646%28v=sql.80%29.aspx
Happy Holidays!Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool0 -
I have used the bcp utility before for mass data imports and exports, and it is very fast.
I loaded data into a working table, then used SQL to fix data errors, then more SQL to move it to the final table.
You could also define the table in NAV.
Definitely worth looking at.David Machanick
http://mibuso.com/blogs/davidmachanick/0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions