Newbie Question

  • Sorry for this newbie question, but what is the best way to push out data from a development server to a production server. I have specific tables in a DB that I want to push out to the production server while keep the identity fields intact.  Any links or suggestions would be appreciated.  I'm looking for best/standard pratices so I can stop doing it the wrong way...

    Thanks!

  • DTS would probably be simplest.

    ------------

    Ray Higdon MCSE, MCDBA, CCNA

  • DTS is probably the simplest if it's a few tables and you are doing it rarely. Be sure you check the "keep identity" box.

  • I like SQL Data Compare from RedGate, think maybe ApexSQL has a tool that does it too (I know it compares schema, not sure about data). It scripts it over, nice because you can see what needs to be added, changed, deleted.

  • Just want to add:

    What about using the Import/Export Wizard?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • 1) DTS

    2) SSIS

    3) SSRS report with time subscription in excel format.

  • you seem to be making several postings to very old threads......????

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • Please note: 9 year old thread. Also, neither SSIS nor SSRS exist in SQL 2000, they're in 2005 and onwards

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Wow, this is a blast from the past! I posted this 9 years ago when I first started my job. Just to let everyone know, I figured it out, so thanks 😉

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply