<div>
Have you tried this query?<br />
<br />
select * from gamrestore..contact1 into<br />
gam..contact1 where gamrestore..contact1.accou<wbr />ntno = 44053
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We have a SQL 2000 server and unfortunatly about 2000 records have been deleted from 4 tables within the system, now I have a backup from last night, however I CANNOT restore the entire backup due to the nature of the DB and data held on it. However, the data that is missing all relates to one 'entity' and so can be found by filtering by their primary ID called accountno.<br />
<br />
So I have 2 databases GAM and GAMRESTORE, now I need to copy all the rows of data found in the CONTACT1, CONTACT2 and CONTHIST tables from GAMRESTORE into GAM where the accountno (primary key) is equal to 44053. Both database's in regards to table's are exact.<br />
<br />
How can I do this? I only need the rows that have the ID of 44053 ....<br />
<br />
Thanks<br />
Mike
</div>
</div>


Hi,

We have a SQL 2000 server and unfortunatly about 2000 records have been deleted from 4 tables within the system, now I have a backup from last night, however I CANNOT restore the entire backup due to the nature of the DB and data held on it. However, the data that is missing all relates to one 'entity' and so can be found by filtering by their primary ID called accountno.

So I have 2 databases GAM and GAMRESTORE, now I need to copy all the rows of data found in the CONTACT1, CONTACT2 and CONTHIST tables from GAMRESTORE into GAM where the accountno (primary key) is equal to 44053. Both database's in regards to table's are exact.

How can I do this? I only need the rows that have the ID of 44053 ....

Thanks
Mike

Have you tried this query?

select * from gamrestore..contact1 into
gam..contact1 where gamrestore..contact1.accountno = 44053

Copy data between 2 tables on 2 different database&#39;s

Hi,

We have a SQL 2000 server and unfortunatly about 2000 records have been deleted from 4 tables within the system, now I have a backup from last night, however I CANNOT restore the entire backup due to the nature of the DB and data held on it. However, the data that is missing all relates to one &#39;entity&#39; and so can be found by filtering by their primary ID called accountno.

So I have 2 databases GAM and GAMRESTORE, now I need to copy all the rows of data found in the CONTACT1, CONTACT2 and CONTHIST tables from GAMRESTORE into GAM where the accountno (primary key) is equal to 44053. Both database&#39;s in regards to table&#39;s are exact.

How can I do this? I only need the rows that have the ID of 44053 ....

Thanks
Mike

Copy data between 2 tables on 2 different database's

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.