Post reply

Replicate Schema but not table Rows

  • May 9, 2014 at 12:57 pm

    #285482

    Hi, i have SQL Server 2008 R2 and i need perform the replication between two database, production and test. But i need replicate the schema of all tables but the content of rows only for some tables, not for all. For example users, logins, logs etc.

    How can i do this?

    Thanks

    Regards

    Damián Fiorito

  • May 9, 2014 at 4:44 pm

    #1712352

    Would it be a recurrent process? or a single-time replica?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • May 10, 2014 at 11:44 am

    #1712405

    Hi, a recurrent process. Right now im performing transactional replication but i wan't exlude all the data of some tables for the syncronization.

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

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