Question about copying data from tables.

[Neozero]

I have a database that I want to move data out of and into another database. The deal is, both databases are the same however one has more data than the other. What I want to do is move the data from the one that has more to the new database. I have about 5 months worth of data from last year that I need to put into my new database that started in January. I guess I want to call this data History that I am moveing from the old database to the new. Is there a function in SQL or a SQL Statement function that I should use to move this data ? Any suggestions would be helpful.



Neozero

 

[JamesLean]

Assuming both DBs on same server:

INSERT db2.dbo.tbl
SELECT *
FROM db1.dbo.tbl
WHERE <criteria>

--James