Import and export to more tables data in sql server 2005

ahmedba

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

udayrmer

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

ahmedba

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

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.

stryk

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!

davmac1

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.