Migrate data from one table to another table?

What software do you use and recommend to easily import data from one databas开发者_开发知识库e table to another database table?

Your question is pretty low on detail. So, my answer may be overkill. Or it may be just what the doctor ordered. But you state in a prior comment you have "many tables". It might be worth your time to learn how to use SQL SERVER INTEGRATION SERVICES (SSIS).

It can be intimidating at first... but once you get the hang of it, it's not too bad - and very powerful.

The following is a good tutorial to get you started:

http://msdn.microsoft.com/en-us/library/ms169917.aspx

This tutorial is also good:

http://www.mssqltips.com/tutorial.asp?tutorial=200

If that is way more than you need. You might also try the Import/Export Wizard that comes in SQL Server Management Studio.

Right click on the database and look under Tasks for the "Import Data..." or "Export Data..." menu items. This gives you a wizard that you can specify data from another database, or a single table, or a flat file etc etc etc.

Is there a reason you can't use SQL Server for this? It's incredibly easy, especially in later versions...

INSERT INTO MyTarget t
SELECT * FROM MySource s 
WHERE NOT EXISTS (SELECT 1 FROM MyTarget t2 WHERE t2.key = s.key)

You can also use an EXCEPT clause if you want to exclude certain data.