How do I copy table structure and data from one database server to another?

Posted on 2009-12-28
Last Modified: 2012-05-08
I have a dba in a dev environment and the same dba exists on the prod server. I need to copy an existing table from dev to prod. How do I do that?

Dev server:
Catalog Name: Budget
Table Name: BU_2010

Prod Server
Catalog name: Budget
Table name from dev needs to be copied to prod

Question by:JessyRobinson1234
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    try this sp to generate the insert script
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    LVL 60

    Expert Comment

    right click the database in management studio, go to tasks, then export data.  from there, there is a wizard that guides you.  integrations services is what powers it from behind.
    LVL 60

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    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…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now