There is already a schema with this name

way0utwestway0utwest Posts: 312 Rose Gold 1
edited May 25, 2016 3:10PM in DLM Dashboard
Am I limited to having a version of a schema across all databases on one instance?

I have two databases being monitored on one instance, but when I tend to acknowledge changes and set the schema to version 1.3 for database 2, I get the error that this schema exists, even though it only exists for database 1.
Editor, SQLServerCentral
· Share on Twitter

Comments

  • Sergio RSergio R Posts: 610 Rose Gold 5
    Hi,

    I am afraid that this is by design: schema name should be unique within a pipeline and since it is possible to move schemas between pipelines they need to be unique globally.

    I suggest you use a unique prefix to each database, for example: DB1 - version 1.3 and DB 2 - version 1.3

    Thank you,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
  • jnguyen714jnguyen714 Posts: 1
    Hi,

    Can the "name this schema" be disable on the review page?

    Thanks,
    Johnny
    · Share on Twitter
  • carthorncarthorn Posts: 5 New member
    So, what if a schema in two difference databases matches 100% in Compare 11, shouldn't DLM also see that those schema's match?
    · Share on Twitter
Sign In or Register to comment.