Filter domain name during synchronization

PSDBAPSDBA Posts: 5
edited June 5, 2009 12:17AM in SQL Compare Previous Versions
We are using SQL compare to perform our daily database implementation. However moving forward to use windows authentication, we are facing problem because of having two different domains for test and production environments. Thus, the domain names are different even though the domain account or domain group are the same. The domain design was recommended by Microsoft.

In SQL compare 8, there is no way to filter domain name during synchronization of database object from test environment to production environment.

So can put in this very useful feature in the coming version? Or it is a way to do it in current version?
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    Hi,

    Thanks for your request. could you please post an example of what is happening how and what you would like to see? Which objects are affected?

    Thanks,

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • PSDBAPSDBA Posts: 5
    The scenario is like this:

    On the Test DB Server we have a domain account (TEST\USER1)

    On the Live DB Server we have a domain account (LIVE\USER1)

    We wish to synchronize the permission across these domains.
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,458 Rose Gold 2
    Thanks. So you need some sort of domain mapping ability, rather like is already possible for schema mapping?

    It would be interesting to hear from anyone else with a similar issue.

    I've noted this as a feature request.

    Kind regards,

    David Atkinson
    Red Gate Software
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • PSDBAPSDBA Posts: 5
    Yes a domain mapping ability would be great!
    · Share on Twitter
  • PSDBAPSDBA Posts: 5
    In total we have more than 10 licenses of SQL compare in the company, we are greatly apprieciated that domain mapping is avaialble to use in next version or update realease in next 2 months time.

    Otherwise, we will be suffered from the manual job on daily implementation for long period of times.

    Also, for a suggestion, how about a filter option for domain name which mean the software will compare the NTUserName (USER1) only instead of domain account (TEST\USER1).

    Last but no least, we are heavily use of SQL compare on daily basis so we hope domain mapping can be introduced in next 2 months.

    Thanks.
    · Share on Twitter
Sign In or Register to comment.