Post reply

copy data

  • August 12, 2011 at 5:57 pm

    #246200

    I would like to know how to copy data from the user acceptance test database server to my unit test database server. Both tables have the same format. I just need to obtain data to test with. The only way I can see to accomplish this task is to use the import wizard on the sql server 2008 r2 database.

  • August 12, 2011 at 6:30 pm

    #1368284

    The import/export wizard is the easiest way.

    There is no copy/paste function you can use. Any other method, outside of a third party tool, will be slightly more complicated.

  • August 15, 2011 at 4:06 am

    #1368493

    If you allowed to link your servers you can use just insert query

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 3 posts - 1 through 3 (of 3 total)

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