Post reply

Replicating tables (temp) on another server

  • July 1, 2013 at 6:43 am

    #395065

    Hello all.

    I am in a situtation where I need to take data from a few of tables from our internal SQL Server (secured), create a few temp tables, and throw them out on a public web server every morning.

    Not having done this before, I am asking for some advice from anyone who has done this before. Generally speaking, what would be the best method of doing this?

  • July 1, 2013 at 9:35 am

    #1628758

    There are few ways to implement such thing.

    Actual strategy would depend on many factors.

    In general, I would use SSIS to perform such task.

    _____________________________________________
    "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 2 posts - 1 through 1 (of 1 total)

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