• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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