• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Microsoft SQL Copy and Replace Tables from one Database to Another

Hi,

How can i copy and replace Tables from a source database to another target database.

The issue that i have is that we just started to use reporting services and it points to a database on another server (our reporting server) to distribute reports.  In the past we just did a MS SQL database restore to the server and manually ran reports.  This solution will not work now because we have created custom stored procedures on the report database and the restore will overwrite the stored procedures

Thank you for all of your help in advance
0
thomasm1948
Asked:
thomasm1948
2 Solutions
 
vbNewbie2009Commented:
Try rigt clicking on the DB, within Tasks click export and follow the wizard to export the table structure and data to another database.
0
 
sarabhaiCommented:
On target machine the Table already exists or not?
0
 
Alpesh PatelAssistant ConsultantCommented:
Its good to have back up and restore.

OR

Create script of objects and Import/Export for Data.
0
 
thomasm1948Author Commented:
I got it to work, I went importing the tables versus exporting and it worked out perfectly
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now