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.
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\Tableset 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. |
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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. |
|
|
|
|
|