SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 update 1 database to another
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hbadministrator
Posting Yak Master

118 Posts

Posted - 04/09/2013 :  14:19:34  Show Profile  Reply with Quote
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

118 Posts

Posted - 04/09/2013 :  14:41:13  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 04/09/2013 :  14:46:09  Show Profile  Reply with Quote
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

118 Posts

Posted - 04/09/2013 :  14:55:17  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000