[Noob_Question]Important, replace table

04/05/2012 13:37 RappelzFenix#1
Hello, I am sure some say i'm noob, it isn't problem xD

How i can replace one table in my db with other?
04/05/2012 14:22 Judge12#2
[Only registered and activated users can see links. Click Here To Register...]
04/05/2012 14:33 ismokedrow#3
Since I haven't ever seen you outright begging and ...well I am bored :P

If you were trying to do something like:

Arcadia_OLD
to
Arcadia

you would:

1) Right click 'Arcadia'
2) Hover over 'Tasks'
3) Left Click 'Import Data'
4) Follow Prompts
5) Use '(local)' as the database
6) Select the database to copy 'FROM' (very bottom, drop down list) [Arcadia_OLD]
7) Press 'Next'
8) Select the database to copy 'TO' (very bottom, drop down list) [Arcadia]
9) Press 'Next'
10) Check 'Specific Objects'
11) Check the dbo or dbo's that you wish to import
12) Click 'Finish'
13) Click 'Finish' Again

-- Make sure you delete the dbo or dbo's in question from the database you're copying the table to, just to make sure of no conflicts. --