Microsoft SQL Copy and Replace Tables from one Database to Another

Posted on 2011-05-03
Last Modified: 2012-06-21

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
Question by:thomasm1948
    LVL 1

    Accepted Solution

    Try rigt clicking on the DB, within Tasks click export and follow the wizard to export the table structure and data to another database.
    LVL 9

    Expert Comment

    On target machine the Table already exists or not?
    LVL 21

    Assisted Solution

    by:Alpesh Patel
    Its good to have back up and restore.


    Create script of objects and Import/Export for Data.

    Author Comment

    I got it to work, I went importing the tables versus exporting and it worked out perfectly

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    MS SQL - Output to columns equally. 5 42
    Why does this keep coming up NULL? 2 28
    sql calculate reminders 11 52
    SQL help 5 42
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now