Skip to main content

Posts

Showing posts with the label sql server 2005 data transfer

Import/Export data with SQL Server 2005 Express - DTS Wizard

After using the simple sql server 2005 data transfer utility for some days I thought to add more functionality such as import export data from excel, CSV, flat file etc. Before start coding I just did a Google search and found this big and interesting discussion in MSDN forums. In the first page developers were really annoyed with the fact MS is not giving a data transfer utility with Sql Server Management Studio Express. I read the conversation one by one and in the 5th page I found this posting by Bill Elicson. MS actually has a really great DTS tool for sql server management studio express. Thanks Bill.. you saved alot of time. STEPS TO ADD DTS WIZARD WITH SQL SERVER MANAGEMNT STUDIO EXPRESS 1. Try "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe" If it worked, you already have the DTS Wizard. Start using it right away. If it will not work, continue to step 2 2. Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) from http://go.mi...

Sql Server 2005 Express Data Transfer

Since there is no mechanism to transfer data from one DB to another in Free SQL Server 2005 Management Studio Express I thought to write a simple utility to do this. It’s so simple that you can use with only MS Sql Server and transfer data from one table at a time. The utility is using ADO.Net SqlBulkCopy class to achieve the functionality. Steps to transfer the data from one DB to another Enter DB connection information of both Source DB and Destination DB. Click Connect If there is no error in the connection details it will establish connections to both server and list all the tables in both Db in bottom combo boxes. Choose the source table from left side combo box and designation table from right side combo box. Click Transfer. Notes Work only with Sql server. Tested only in Sql server 2005. Both source table and destination table should be similar. Sql2005_DataTransfer.zip