Import and export to more tables data in sql server 2005

ahmedba
ahmedba Member Posts: 424
edited 2012-12-20 in SQL General
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

Comments

  • udayrmer
    udayrmer Member Posts: 171
    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 download
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • ahmedba
    ahmedba Member Posts: 424
    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
    thanks
  • udayrmer
    udayrmer Member Posts: 171
    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 Consultant
  • stryk
    stryk Member Posts: 645
    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 Tool
  • davmac1
    davmac1 Member Posts: 1,283
    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/

Categories