Skip to main content

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

  1. Enter DB connection information of both Source DB and Destination DB.
  2. 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.
  3. Choose the source table from left side combo box and designation table from right side combo box.
  4. Click Transfer.
Notes
  1. Work only with Sql server.
  2. Tested only in Sql server 2005.
  3. Both source table and destination table should be similar.

Sql2005_DataTransfer.zip




Labels:

Comments

Anonymous said…
Thanks for posting this...I have adapted it into a service format for my usage but it was just what I needed!
July 30, 2008 at 8:43 AM
Anzer said…
HI Warren,
Please see this Posting..

http://anzme.blogspot.com/2008/06/importexport-data-with-sql-server-2005.html

Actually there is a full featured DTS available for FREE from MS, but its not coming along with the SSMSE, you have to download and install it separately.

Best Regards
August 3, 2008 at 5:42 AM
Post a Comment

Popular posts from this blog

Asp.Net CAPTCHA and Asp.Net AJAX CAPTCHA

I am using a great Asp.Net CAPTCHA by BrainJar in a number of web sites with and without Asp.Net AJAX. It’s a simple and really easy to use Asp.Net CAPTCHA. The actual source code is in C#, but you can use it with both C# and VB.Net by simply wrapping the functionality in a class library. In Asp.Net forums and in many other user communities I have seen lot of people asking for VB.Net CAPTCHA. So I thought to write a blog post and create some sample implementations. The zip file contains C# CAPTCHA and VB.Net CAPTCHA. I have included the samples for Asp.Net AJAX CAPTCHA also. You can download the samples and implementation from here Implementing Asp.Net AJAX CAPTCHA is really simple. Just wrap the main Asp.Net CAPTCHA with Asp.Net AJAX update panel and put a random query string at the end of CAPTCHA image src. The random query string will avoid showing the old CAPTCHA from browser cache. STEPS TO ADD ASP.NET CAPTCHA IN YOUR WEBSITE Refer the assembly CaptchaDLL.dll in your project Copy...
23 comments
Read more

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...
15 comments
Read more

Simple Numeric Pagination for DataList and Repeater

There are a big number of tutorials available on how to implement pagination in asp.net DataList and Repeater. But all of them are explaining only about the Next/Prev mode of pagination only. Recently I have implemented a quick and dirty numeric pagination on DataList for one of my project. The idea is simply use a PagedDataSource to get the current page of data and bind it to DataList or Repeater. Now create dynamic Linkbuttons using the PageSize and the Total rows count. See the code below. ASPX Code <head runat="server"> <title>Untitled Page</title> <style type="text/css"> .pagination a{padding:5px;} .pagination span{padding:5px;} </style> </head> <body> <form id="form1" runat="server"> <div> <asp:DataList ID="dlPaginationSample" runat="server"> <ItemTemplate> <%# Eval("Column1")%> | <%# Eval(...
10 comments
Read more