<div>
Hi,<br />
<br />
I am sure i can help. But I will need a sample query that you have to displaying the data.<br />
<br />
I can then quickly give you an equivalent insert query.<br />
<br />
Also, help me understand if both the databases are on the same server?
</div>


Hi,

I am sure i can help. But I will need a sample query that you have to displaying the data.

I can then quickly give you an equivalent insert query.

Also, help me understand if both the databases are on the same server?

<div>
As you already have a query displaying the data you want in db02, just make sure it has all fields in the table field order and you can do<br />
<br />
insert into db02.dbo.table<br />
(....your select from db01.dbo.table here...)<br />
<br />
The only other prerequisite is both databases are on the same server instance, so you can address the tables as db01.dbo.table and db02.dbo.table.<br />
<br />
Bye, Olaf.
</div>


As you already have a query displaying the data you want in db02, just make sure it has all fields in the table field order and you can do

insert into db02.dbo.table
(....your select from db01.dbo.table here...)

The only other prerequisite is both databases are on the same server instance, so you can address the tables as db01.dbo.table and db02.dbo.table.

Bye, Olaf.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have two separate databases. &nbsp;DB01 and DB02<br />
<br />
DB01 contains data that is not present in DB02 and the task here is to get data from DB01 into DB02.<br />
<br />
I have so far written an SQL statement to get the data that I need displayed. &nbsp;Can this be easily turned into the relevant insert statements?<br />
<br />
Any other suggestions appreciated. &nbsp;I’m using SQL Server &nbsp;Management Studio?<br />
<br />
Thanks in advance.
</div>
</div>


Hi,

I have two separate databases.  DB01 and DB02

DB01 contains data that is not present in DB02 and the task here is to get data from DB01 into DB02.

I have so far written an SQL statement to get the data that I need displayed.  Can this be easily turned into the relevant insert statements?

Any other suggestions appreciated.  I’m using SQL Server  Management Studio?

Thanks in advance.

Inserting SQL

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.