Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [schema]

A schema describes the structure of various elements like tables, fields, objects, attributes, etc. for example for a database or a directory.

112 questions
36
votes
2 answers

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
warren
  • 17,829
  • 23
  • 82
  • 134
20
votes
2 answers

How to migrate LDAP (database,schema,configuration) to other machine

I'm using openldap 2.4.40, and i need to migrate my existing ldap database, configuration, and schema (basically everything ldap server related) to a new machine. the problem is, I use cn=config configuration not the old slapd.conf file anymore. The…
J_LDAP
  • 588
  • 1
  • 4
  • 11
16
votes
1 answer

What's the required to make a normal user can create schema on PostgreSQL?

I created a new database test and created user 'eonil' with this command: CREATE ROLE eonil LOGIN ENCRYPTED PASSWORD 'password' NOINHERIT VALID UNTIL 'infinity'; on my PostgreSQL. I run psql -U eonil test. When I tried to make a new schema, it…
Eonil
  • 9,689
  • 15
  • 34
  • 53
15
votes
1 answer

Where does Active Directory-integrated DNS store its data?

This has been bugging me for a while. We all know Active Directory is a LDAP database. We also know that the Windows DNS service, when running on a domain controller, can store its data in AD instead of plain text zone files, thus taking advantage…
Massimo
  • 68,714
  • 56
  • 196
  • 319
13
votes
3 answers

Where do I store sensitive data within Active Directory?

I am essentially storing a private key (Hash) in any of the OctetString attributes within Active Directory. My question is, what attribute is secure by default and makes sense to keep private data there? This value should be considered similar to a…
makerofthings7
  • 8,821
  • 28
  • 115
  • 196
13
votes
3 answers

How safe are Windows Active Directory Schema Updates?

I'm trying to get a better understanding about how Active Directory handles Schema updates, specifically how safe the procedure actually is given how critical AD is and given the range of situations where updates are required. Exchange 2007, OCS,…
Helvick
  • 19,579
  • 4
  • 37
  • 55
10
votes
1 answer

AD custom attribute of type numerical string crashes MMC when updated

I am using windows server 2008. I have a domain with one domain controller (this is a dev environment). I edited the AD schema and created a custom attribute called TestAttribute2 (the LDAP name is testAttribute2) with a syntax of numerical…
Falcon Momot
  • 24,975
  • 13
  • 61
  • 92
9
votes
3 answers

SQL Server 2008 default schema not being respected?

We just copied a SQL 2008 database over to another server, for testing purposes. The typical user that logs in uses some objects in a certain schema. Let's say it's user foo and schema bar. foo's default schema is bar at both the instance and…
John Cromartie
  • 193
  • 1
  • 5
7
votes
3 answers

Where can i find the latest unattended.xml schema (xsd)?

I'm working with Windows Server 2012, Windows Deployment Service (WDS), and Windows Assessment and Deployment Kit (ADK). I created a base unattended.xml file. When I go to edit in an xml editor it's actually a bit annoying since I don't have an…
myermian
  • 131
  • 1
  • 8
6
votes
2 answers

Is it possible for a schema change to not replicate, and a object that uses that schema arrive at a DC?

I'm trying to understand the risk of updating the schema of a very large AD forest, where the schema has not been on every DC, and then an object that uses that schema object is replicated An example is Lync setup, where it requires a schema change,…
makerofthings7
  • 8,821
  • 28
  • 115
  • 196
6
votes
1 answer

openLDAP how to remove the nis schema from the current configuration

openLDAP 2.4 Ubuntu 14.04 I have found this question dn-based linux groups from ldap. I am trying to include the rfc2307bis schema, but it seems the nis schema must be removed from the configuration before including rfc2307bis. How can I remove this…
lk7777
  • 143
  • 1
  • 9
6
votes
4 answers

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
Chad Johnson
  • 479
  • 2
  • 7
  • 14
6
votes
9 answers

One Database vs. Multiple Databases

I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project has the same data model, but is independent of all…
Ricardo Sanchez
  • 195
  • 1
  • 6
5
votes
4 answers

Moving a table to a different schema in Oracle

How do I move a table from one schema to another? It's a fairly large table, so the following query would take ages to complete and need huge disk space: CREATE TABLE newschema.mytable AS SELECT * from oldschema.mytable; I tried to rename the…
Henning
  • 213
  • 1
  • 3
  • 7
5
votes
1 answer

What are best practices to store delegated permissions in OpenLDAP?

My network's core user database is managed by OpenLDAP. Recently we need to introduce a possibility for one user to act on second user's behalf. As all application-related rights and permissions are stored in the LDAP we also want to store the new…
hegemon
  • 165
  • 1
  • 6
1
2 3 4 5 6 7 8