I have 2 database one contains...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

I have 2 database one contains...

Author

Topic

asifbhura
Posting Yak Master

165 Posts

Posted - 2006-07-01 : 08:43:28

Dear

I have 2 database named with khaleej and aswaq.
both are same.

in khaleej database i have added news stored procedures and some new tables,

in aswaq database, I have data.

I want that, is there any way which copy only data from aswaq to khaleej database.

means only copy data from aswaq to alkhaleej.newly added procedures and tables must be remained as it is.

waiting for reply.

best regards,
ASIF

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-01 : 08:49:16

Make use Import/Export feature from EnterPrise Manager

Madhivanan

Failing to plan is Planning to fail

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-07-01 : 10:18:07

if the 2 database are of same server, you can simply specify via databasename.owner.table to access it
eg.


insert into khaleej.dbo.table (. .  .)
select . .  .
from   aswaq.dbo.table
where  . . .

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources