tagged [schema]
How do I change db schema to dbo
How do I change db schema to dbo I imported a bunch of tables from an old sql server (2000) to my 2008 database. All the imported tables are prefixed with my username, for example: `jonathan.MovieData...
- Modified
- 10 Apr at 17:28
Relax NG and uniqueness of elements/attributes
Relax NG and uniqueness of elements/attributes is it possible to make a Relax NG element/attribute unique? For example the attribute: references to: ``` t1 t2 t3
How to store arrays in MySQL?
How to store arrays in MySQL? I have two tables in MySQL. Table Person has the following columns: | id | name | fruits | | -- | ---- | ------ | The `fruits` column may hold null or an array of strings...
- Modified
- 15 Jun at 23:32
Entity Framework 4: Code First - Creating db in another schema? MapSingleType?
Entity Framework 4: Code First - Creating db in another schema? MapSingleType? I have a database and I am using two different schemas. Schemas are like namespaces (correct me if I am wrong). This way ...
- Modified
- 5 Nov at 21:47
XSD.exe and "Circular Group references"
XSD.exe and "Circular Group references" I am attempting to build some classes so that I can deserialise an XML file created by a third party application. Luckily the developer of the 3rd party applica...
XML Schema (XSD) validation tool?
XML Schema (XSD) validation tool? At the office we are currently writing an application that will generate XML files against a schema that we were given. We have the schema in an .XSD file. Are there ...
- Modified
- 15 Sep at 14:35
How to SELECT in Oracle using a DBLINK located in a different schema?
How to SELECT in Oracle using a DBLINK located in a different schema? We have an Oracle DBMS (11g) and the following configuration: - - - - - : When logged on as "MYUSER", what is the correct syntax t...
- Modified
- 28 Sep at 09:23
Entity Framework 4 Generate Database From Model With Multiple Schemas
Entity Framework 4 Generate Database From Model With Multiple Schemas I am using EntityFramework 4 with POCO classes, but I like to divide the database up into separate schemas. While I can do this by...
- Modified
- 23 Aug at 08:21
Validate XML against XSD in a single method
Validate XML against XSD in a single method I need to implement a C# method that needs to validate an XML against an external XSD and return a Boolean result indicating whether it was well formed or n...
- Modified
- 5 Apr at 09:23
app.config configSections custom settings can not find schema information
app.config configSections custom settings can not find schema information I am just learning about app.config in respect of creating custom sections. I have that part working, it compiles and gets the...
- Modified
- 23 Oct at 09:55
Fluent nHibernate: Use the same mapping files for tables with the same structure in different schemas
Fluent nHibernate: Use the same mapping files for tables with the same structure in different schemas This is my mapping class: This works fine for the Table ([mySchema].[MyTable]) in my first databas...
- Modified
- 18 Feb at 15:36
Read file from resources folder in Spring Boot
Read file from resources folder in Spring Boot I'm using Spring Boot and `json-schema-validator`. I'm trying to read a file called `jsonschema.json` from the `resources` folder. I've tried a few diffe...
- Modified
- 6 Jun at 20:38
article table schema
article table schema I need to create the typical crud app for "articles", is there a standard or sort of a best practice when it comes to this? I know every app and situation varies, but I mean gener...
- Modified
- 3 Jun at 20:51
How can I export the schema of a database in PostgreSQL?
How can I export the schema of a database in PostgreSQL? My computer broke down but fortunately I backed up the folder C:\Program Files\PostgreSQL. Now I'm working in a new computer and I would like t...
- Modified
- 4 Dec at 16:34
What does GRANT USAGE ON SCHEMA do exactly?
What does GRANT USAGE ON SCHEMA do exactly? I'm trying to create a Postgres database for the first time. I assigned basic read-only permissions to the DB role that must access the database from my PHP...
- Modified
- 21 Apr at 09:1
How can I initialize a MySQL database with schema in a Docker container?
How can I initialize a MySQL database with schema in a Docker container? I am trying to create a container with a MySQL database and add a schema to these database. My current Dockerfile is: ``` FROM ...
- Modified
- 24 Jul at 12:27
Creating XML with namespaces and schemas from an XElement
Creating XML with namespaces and schemas from an XElement A longwinded question - please bear with me! I want to programatically create an XML document with namespaces and schemas. Something like ```
- Modified
- 2 Dec at 19:30
ASP .NET WebAPI Route Data Schema
ASP .NET WebAPI Route Data Schema Currently, we are using a route like this: Rather than using `dynamic`, I'd like to have a schematic understanding of the data coming in. So I could use a setup like ...
- Modified
- 4 Nov at 16:5
Is it OK to update a production database with EF migrations?
Is it OK to update a production database with EF migrations? According to [this blog post](http://cpratt.co/migrating-production-database-with-entity-framework-code-first/) most companies using EF Mig...
- Modified
- 20 Apr at 19:43
Dynamically changing schema in Entity Framework Core
Dynamically changing schema in Entity Framework Core [here](https://stackoverflow.com/a/50529432/3272018) is the way I solved the problem. Although it's likely to be not the best one, it worked for me...
- Modified
- 14 Jun at 09:19
How to fix Error: "Could not find schema information for the attribute/element" by creating schema
How to fix Error: "Could not find schema information for the attribute/element" by creating schema I have a windows forms application written in VS2010 with C# and get the following errors in the `app...
- Modified
- 13 May at 16:58