An ADO Based Data Copying Utility

Click here for larger image

Environment: VC6 MFC and needs MDAC if not already available [eg VC6 SP4, NT4 SP3, winCE 2.0]

This is a simple utility that helps in copying data from one data source to another. I wrote this because I could not find any other utility for this surprisingly mundane operation. It can certainly do with improvements in the validations and the UI.

The GUI uses the property list control by Matt Gullett available here on CodeGuru.

To use the application just enter the DSN name for the source and target database, enter the tables names, login and passwords. Choose the field mapping and hit copy.

All the best... In case you can think of doing any improvements or addition of features... please do go ahead...


Download source - 47 Kb


  • DTS

    Posted by Legacy on 03/02/2003 12:00am

    Originally posted by: Jimmy Jackson

    There is a utility that does this and more

    Its called DTS (data transformation service)

    It comes with SQL SERVER and very powerfull tiio to transform data to one formate to another

  • problem in Release mode

    Posted by Legacy on 11/25/2002 12:00am

    Originally posted by: Anon

    There seems to be a strange problem, this works fine in debug mode but fails silently :( in release mode !

  • Comment

    Posted by Legacy on 08/02/2002 12:00am

    Originally posted by: Warz

    This program is excellent.
    It will be better if there explaination on the codes coz it's hard to understand.

  • good work

    Posted by Legacy on 04/17/2002 12:00am

    Originally posted by: Sanjeev

    Good work Shyamal. I needed very similar tool, now I can use this one :)

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Thanks to the Internet of Things (IoT), physical assets are turning into participants in real-time global digital markets. The countless types of assets around us will become as easily indexed, searched and traded as any online commodity. While some industries will be tougher to transform than others – those with physical limitations, such as manufacturing, will be harder to digitize – untold economic opportunities exist for growth and advancement. Our research shows this will create a new "Economy …

  • Lenovo recommends Windows 8 Pro. "I dropped my laptop getting out of the taxi." This probably sounds familiar to most IT professionals. If your employees are traveling, you know their devices are in for a rough go. Whether it's a trip to the conference room or a convention out of town, any time equipment leaves a user's desk it is at risk of being put into harm's way. Stay connected at all times, whether at the office or on the go, with agile, durable, and flexible devices like the Lenovo® …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date