Is there a "universal unique identifier" for the ASA12-database?
Is it possible to use DB_PROPERTY('IdentitySignature') as such an identifier?

asked 25 Feb '15, 06:18

Ilia63's gravatar image

Ilia63
801283452
accept rate: 16%

What are you trying to do - distinguish different databases from another or assuring that you are conecting to the "right" database and/or "right" database server or something else?

If related to the database file per se: Would you expect that a "copied" database (or a backup) has still the same UUID? Would you set the value yourself?

(25 Feb '15, 06:34) Volker Barth
Replies hidden

I want to be sure that I connect to the "right" database.
And I need to database ID does not change when I copy the database file.

(25 Feb '15, 06:41) Ilia63

Then the following FAQs may be of help:


However, these FAQs do not deal with the question whether the running database is the "right" one, i.e. whether the correct database file has been loaded. Say, if you have 10 different databases with the same schema, they don't tell if the desired database (say, here database 3) has been loaded. In case you know the file location then db_property('File') may help.

For databases used with replication/synchronization, they usually can be identified via CURRENT PUBLISHER or the remote ID. For general purpose databases, I would think you would have to "label" them yourself, e.g. via a user-defined SET OPTION.

permanent link

answered 25 Feb '15, 07:16

Volker%20Barth's gravatar image

Volker Barth
31.3k312458674
accept rate: 33%

Thanks... (although such an identifier would not be superfluous when the databases with one and the same filename & with one and the same scheme to migrate to the cloud and the client application must ensure that it has connected to "right" database).

(25 Feb '15, 07:44) Ilia63
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×413

question asked: 25 Feb '15, 06:18

question was seen: 340 times

last updated: 25 Feb '15, 07:44