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 2008 Forums
 Transact-SQL (2008)
 update 1 database to another

Author  Topic 

hbadministrator
Posting Yak Master

120 Posts

Posted - 2013-04-09 : 14:19:34
I have 2 tables I want to update a Live Table to a Training table. Without having to backup and restore the whole database.

I was thinking.

update ServiceTR.dbo.[ar-open-item] << Training Database\Table
set
ServiceTR.dbo.[ar-open-item] = Service.dbo.[ar-open-item] << Live Database\Table

hbadministrator
Posting Yak Master

120 Posts

Posted - 2013-04-09 : 14:41:13
Disregard this, I deleted the database's from the training database then did an import on ServiceTR db from Service db and just selected those 2 tables and it copied them over with no issue.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-09 : 14:46:09
update what fields? whats the primary key of the table?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

hbadministrator
Posting Yak Master

120 Posts

Posted - 2013-04-09 : 14:55:17
All I needed was to do was copy live tables only 2 of them and replace 2 from training, and the import export function worked for what I wanted to to do under the tasks section.
Go to Top of Page
   

- Advertisement -