Moving data from one database to other

[Yoandy Mesa]

hi,
I have to move data that meet certain criteria from one database that have
many tables to another (identical) database. My question is what is the best
way to do it?
Should i make an stored proc that make the processing in this way:
select from db1.table1 where field1='something'
insert data selected from db1.table1 into db2.table1
delete from db1.table1
and son on with every table on bd1 ???

or is there any better way???

 

[Cor Ligthert]

Hi Yoandy

I think that when it was my problem I would use dataset because than it is
very easy to do.

The only thing to remember is this

http://msdn.microsoft.com/library/d...aadapterclassacceptchangesduringfilltopic.asp

And than it should be easy.

I do not know if you use the designer to create your datasets, however while
I seldom do that, I think that I would do that for this problem.

Cor