0

Hello I got a nice one.

I have 2 MS SQL 2000 databases on the same server both are almost alike.
Both have an items table with the field searchcode

I want to copy the searchcode from db1 table1 to db2 table1.

So something like this:

use [db1]
select itemcode,searchcode from table1
use [db2]
update [db2].[dbo].[table1] values ( select itemcode,searchcode from [db1].[dbo].[table1] )

Only this code doesn't work!!!!!!!!!!!!

The itemcodes are equal in both tables!

I want to schedule this to run every night.

This is just an example, but if I can do this, only 1 database needs to be maintained and the other database gets updated every night!

Anybody any ideas?

Thanx for any replies!

Ivan.

3
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by tuukie
0

tuukie,
The syntax for the update statement is incorrect. Have a look in BOL to find the correct statement syntax.
You have the right idea with the [DB_Name].[dbo].table_name. I have used this technique a number of times.

0

To: RamyMahrous
Tried replication, can't do it because an extra field gets added to the table and the software who reads the table rejects that.
To:pclfw
Good to hear that I am on the right track, will have a look, when I find the solution I will post it

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.