Click here to Skip to main content

Submit your article

Schema

schema

Great Reads

MEAN Stack Development Technologies Supporting a Web Tool for Arcade Game Players Collaboration

by André Marcos (Advisor), LaercioMBR

An overview of the development process of an online platform to facilitate community driven data cataloging and management.

A Basic Walkthrough of SQL Schema

by Jin Vincent Necesario

This article shows you the basics of SQL Schema using the DDL statements.

SPDiscover - Testing Large Systems Built on Stored Procedures Rolled into a Simple to Use Program

by DotNetSteve

Testing large systems built on stored procedures can quickly become unyielding. Here are some thoughts on managing the complexity which have been rolled into a simple to use program

Entity framework

by ASP.NET Community

What is Entity Framework?ADO.NET Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework. Basically it represents the

Latest Articles

MEAN Stack Development Technologies Supporting a Web Tool for Arcade Game Players Collaboration

by André Marcos (Advisor), LaercioMBR

An overview of the development process of an online platform to facilitate community driven data cataloging and management.

A Basic Walkthrough of SQL Schema

by Jin Vincent Necesario

This article shows you the basics of SQL Schema using the DDL statements.

SPDiscover - Testing Large Systems Built on Stored Procedures Rolled into a Simple to Use Program

by DotNetSteve

Testing large systems built on stored procedures can quickly become unyielding. Here are some thoughts on managing the complexity which have been rolled into a simple to use program

Introduction to JSON Schema

by Florian Rappl

JSON Schema may be the answer to most problems in dealing with JSON files. We explore JSON Schema from a practical point of view.

All Articles

Schema

MEAN Stack Development Technologies Supporting a Web Tool for Arcade Game Players Collaboration

10 Dec 2020 by André Marcos (Advisor), LaercioMBR

An overview of the development process of an online platform to facilitate community driven data cataloging and management.

A Basic Walkthrough of SQL Schema

7 Dec 2020 by Jin Vincent Necesario

This article shows you the basics of SQL Schema using the DDL statements.

What happens when I alter a table of MS SQL server 2014

9 May 2016 by Kornfeld Eliyahu Peter

I assume you are asking about running an ALTER TABLE [] ADD/DORP/ALTER COLUMN [] query, and not about Management Studio...There are several steps in such query and a lot of depends on, what the column is, and what the state of the current table is (I mean, does the column part of an index, how...

Generate schema for class with jsonconverterattribute

4 Aug 2020 by Member 13668663

I am trying to create a JSON schema with the usage of Json.NET Schema. Anyway, my class has JsonConverter attribute, like in the example below: public class Building { [JsonConverter(typeof(BuildConverter))] public string Name { get; set; }...

SPDiscover - Testing Large Systems Built on Stored Procedures Rolled into a Simple to Use Program

4 Sep 2020 by DotNetSteve

Testing large systems built on stored procedures can quickly become unyielding. Here are some thoughts on managing the complexity which have been rolled into a simple to use program

How can I find a project that compares schema of 2 SQL server databases

10 Dec 2021 by Richard Deeming

Visual Studio already has built-in tools to do this. Tools ⇒ SQL Server ⇒ New Schema Comparison

XML schema validation

20 Sep 2012 by Member 4029130

Hi, I am trying to validate an XML file against a schema, which i can achieve without issue normally, however, in this particular schema, there is an imported namespace, that appears to be preventing the validation from happening, as the error being returned is pointing to node of the...

XML schema validation

21 Sep 2012 by Kuthuparakkal

Use the following xsl to strip off multiple namespaces: ...

what is the usage of schema in biztalk server 2010

22 Oct 2012 by sangeetha m

hi every body,actually i have doubt in message creation in biztalk server 2010?how the message recognize that corresponding schema ?eg: like rootnode or any thing else?so far i was used input schema as message type while creating message in an orchestraion.but i saw one...

what is the usage of schema in biztalk server 2010

22 Oct 2012 by Devang Vaja

hey Read thishttp://msdn.microsoft.com/en-us/library/aa559175.aspx[^]andhttp://msdn.microsoft.com/en-us/library/aa578053.aspx[^]andhttp://en.wikipedia.org/wiki/Microsoft_BizTalk_Server[^]and this is good article about biztalkUnderstanding BizTalk Server - In 47 Words Or Less[^]no...

Oracle database schema creation script in installshield

23 Dec 2012 by Praveen21212

Hi,1) I have created a vb.net application with oracle XE 11g as database. At the time of installation I want the applciation to create the database schema by itself. I am creating installation in installshield 2010. 2) Can I install oracle from installshield script ? If yes how ?If no,...

Deploying multiple similar schemas in biztalk

29 Jan 2013 by hunerajamshed

I have two different servers on which two similar WCF services are running. Both services are exactly same (clone). I have to consume both services in a single orchestration because I have to communicate them with each other. (I am using "Add generated Items" to add service reference). I want to...

Deploying multiple similar schemas in biztalk

2 Feb 2013 by hunerajamshed

As these services are same so just adding service reference for any one of these will add the required schemas.Just create separate send ports for each service in BizTalk MMC and to connect the logical port created in orchestration to correct send port while configuring the orchestration.

I need help with this case. Create a schema for an XML document.

6 Mar 2013 by Sarah Jean

Does anyone know how to create a schema for an XML document? This is the exact instructions, in case it helps. Create a schema for an XML document that will store information about patients in a hospital. Information about patients must include name (in 3 parts), Social Security number,...

I need help with this case. Create a schema for an XML document.

6 Mar 2013 by H.Brydon

This looks like homework. The best answer for this is to consult with your class notes.If it is not homework, you can create a schema in Visual Studio from an existing XML file (your question looks like you create the schema first, then generate xml from it... it is actually easier the...

I need help with this case. Create a schema for an XML document.

7 Mar 2013 by RedDk

It's kind of hard to explain what it is the OP is trying to .. understand. But given the apaucity of TSQL in the question I'd formulate that THAT'S what the question actually is. So ... look for stuff related to these things, here in CPQA, using google, even the BOL:USE...

Oracle database schema creation script in installshield

4 Apr 2013 by Yumashin Alex

Hi Praveen21212,Have you found any solution?I've got the same problem. In my case it's MS SQL XE - but this doesn't matter. I need to create a database and execute some certain scripts on it. VS Setup Project does not offer such functionality, so I thought about the other setup project...

SQL Server Schema creation f or existing database

26 May 2013 by vivek ayyakannu

Hi,I have created a database and all object like tables stored procedure and user defined table type under a default schema (dbo).Now i want to create a new schema and to map all my stored procedure to New schema.So that all changes to the table happens only through stored procedure...

SQL Server Schema creation f or existing database

26 May 2013 by Mycroft Holmes

Create the new schemaScript all the procedures create to SSMS querySearch and replace on dbo replacing it with the new schemarun the scriptYou should now have 2 copies of all the procedures

SQL Server Schema creation f or existing database

27 May 2013 by gvprabu

Hi You can use Query like this...ALTER SCHEMA the destination schema TRASFER Object::current schema.TableName;For Example : ALTER SCHEMA dbo TRANSFER HWData.DesktopSoft_Master;Check the following links...Script to move all objects to a new schema for SQL Server[^]How To Change SQL...

MSoffice 2007 outlook database schema

10 Jul 2013 by keerth516

Hi,I would like to know the database schema/structure of MS office 2007 outlook.So that i can better understand how they are working with outlook data insertion and fields of database table required for contacts and email.I goggled it but could not find any thing..kindly provide me any...

Biztalk Schema for varying role for a given partner

14 Aug 2013 by Toraj Khavari

Biztalk Schema for varying role for a given partnerBackground: I have Biztalk 2010, SQL2008R2 backend. I have flat file source to Biztalk which looks as follows. Field delimited “I” and Record Delimited “”.ENV|prt198623083932|…PAR|TGL|01|104|D05|Partner Name...

cny70 and schmitt trigger

8 Sep 2013 by CPallini

Here you may find some info: "Application of Optical Reflex Sensors"[^].

Biztalk Schema for varying role for a given partner

10 Sep 2013 by Toraj Khavari

Hi:After working at this for a while, there is no easy solution to it than good old XSLT Loop inside a loop. Here what I finally did and working in production.Cheers, Toraj ...

Two different xmlns:xs in XML Schema

15 Sep 2013 by eyalle

Hello All,Here is my problem:i have an xml file which has some values and also this file is certificate signed.my xsd schema file knows how to handle only the values, while when adding the signature lines the schema fails.the error is:The element 'Header' has invalid child element...

Entity framework

11 Oct 2013 by ASP.NET Community

What is Entity Framework?ADO.NET Entity Framework is an object-relational mapping (ORM) framework for the .NET Framework. Basically it represents the

entity-framework

how to import dump file in oracle schema from other schema

25 Mar 2014 by Chaitrali Deshpande

Hi,does anyone know about following issue? I am facing this issue while I try to import one schema file into other schema.Error:Import: Release 11.2.0.1.0 - Production on Wed Mar 26 10:34:52 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights...

How to set table's schema in power designer

24 Apr 2014 by Member 10194508

DBMS: SQL Server 2008for example:I want to create a table like this "Meeting.Appointment"the "Meeting" is a schema namethe "Appointment" is a table name

Generate C# code using Schema file

3 Jul 2014 by johannesnestler

I assume you are talking about an XSD Schema (please be aware that words like template, schema, form etc. have many different meanings, maybe next time put more effort in formulating your question).So if you have a xsd no code is needed for that - just use the XSD.exe tool (Framework Tools)...

How to use powershell to use SQL Schema Comparison

23 Jul 2014 by rhapemerald

Hello, i was assigned with an interesting task. There's a tool in VS that compares SQL-Schemas, it shows the difference and it can generate scripts to alter the one that's different... I'm very new at powershell and i'm creating a CI for a project, i have done several powershell scripts...

SQL-Server-2008R2

Entity Framework 6.1 Error: Schema specified is not valid.

19 Jan 2015 by Member 240806

I have a database that has a many to many between 2 tables. This works fine. I now need to add a second many to many between the same tables. So, following the same approach as with the first relationship, compiling is not problem but adding a migration to support the schema change gives me an...

entity-framework

Stephen Boissiere - Where is Part 3?

4 Mar 2015 by Kornfeld Eliyahu Peter

Probably never wrote it...But you should as him...maybe here: Generate SQL Database Schema from XML - Part 2 (Code Model)[^]

JSON schema design: multiple array properties or one?

17 Apr 2015 by Michael Corbett

I'm working on something with JSON Schema.I'm trying to decide between two ways to structure a part of the schema: A and B are two types of profiles (objects). They share similar properties and differ by only a few (basically, A and B from the application point of view are classes...

JSON schema design: multiple array properties or one?

17 Apr 2015 by Mehdi Gholam

I would go for :{"profiles" : { "A" : [ {}, {}, {}], "B" : [ {} ] }}Which would give you room for "C","D" etc.

Problem with adding fields to existing table/schema

22 Jun 2015 by cindy_m

I’m working on a .Net application in Visual Studio 2008. It contains schemas in a schema project and in a SQL Server project. I’m not very familiar with SQL Server projects and I’m having a problem with updating records that use the insert statement in the server project. I had to add two...

Want table design for different time slots(Normalization)

27 Jul 2015 by Mangesh9692

How to normalize itFor each week no we can define maximum 3 time slots, Category id specifies different categories.For each category we have to define 3 times slots for each week.Category Id Week No Start Time End Time1 1 9:00 1:001 1 3:00 5:101 1 6:00 ...

SQL-Server-2012

Want table design for different time slots(Normalization)

27 Jul 2015 by Wendelius

I probably would create a table similar to your post but add a timeslot number as a column. The timeslot would be unique when combined with week number and category number. Timeslot would also have a check constraint that the value is between 1 and 3.

SQL-Server-2012

Authentication and Authorisation Database Design

2 Aug 2015 by OriginalGriff

Start here: https://msdn.microsoft.com/en-us/library/yh26yfzy.aspx[^] and look at how they do it.

Need Optimization in Database Design

3 Aug 2015 by ZurdoDev

I personally would create a table for storing your permissions. Then a table to store what permissions either a group or user has. I would not concatenate all their permissions together into a single column.

How to write mongoDB query to sum up elements in an array that match another array?

29 Sep 2015 by Ivan.0

In my mongoDB dbs there is a collection A1 that has an array of embedded objects B. I want to group all elements in A1 by the sum of a certain field of B in the array field of A1,namely X. Meanwhile the value of X field need to be an element in another collection A2. That's to say I need to sum...

Openldap updating schema to have more than 1 values for an attribute usersmimecertificate .

10 Feb 2016 by Adithya Ranganath

Hi, I have set up LDAP server using OpenLDAP in Linux Mint. Now, I want to update schema so that I can have more than 1 UserSMIMECertificate attribute for an User in the directory.Can somebody please tell me how to go about it please?What I have tried:I changed the Schema file(in...

Does exist some software for transforming data from one DB schema to another?

12 May 2016 by Member 12387639

I need to transform between two different database schemas the same data. For example i have one table in old schema looking like this:OLD EMPLOYEE TABLEUSER_ID - NUMBER (PRIMARY KEY)FIRST_NAME - VARCHAR(50), (NOT NULL)LAST_NAME - VARCHAR(50), (NOT NULL)CITY - VARCHAR(50), (NOT...

Does exist some software for transforming data from one DB schema to another?

12 Mar 2016 by RickZeeland

A trick you could use is something like:SELECT * INTO Schema2.NewTable FROM Schema1.OldTableBut I think you already have the tools to migrate data between two schema's, take a look at the Bulk Copy utility (BCP) that's included with SQL Server.With BCP you can export and import the...

How do I create .NET class from xsd schema?

5 May 2016 by Kunwar Bahadur Singh

All you have to do is compiling your assembly and run XSD.exe with the path to your assembly as argument. XSD.exe /? has a list of all arguments as well.Example:XSD.exe C:\Dev\Project1\Bin\Debug\library.dll

What happens when I alter a table of MS SQL server 2014

9 May 2016 by herrstress

I would just like to know what happens when I alter a giant table in this database. E.g. when I increase the data space in a column or remove or add one...Is the table recreated in a long process or can this happen without further changes on storage level...?Thank you in advance!What...

What happens when I alter a table of MS SQL server 2014

9 May 2016 by HobbyProggy

Basically nothing special would happen. If you just increase the charcount on a column that's nothing special, if you add a new column it should also work fine but i personally would recreate the table, import the data from the old into the new one and then delete the old table. That's...

Does exist some software for transforming data from one DB schema to another?

12 May 2016 by SMerrill88

Start the SQL Server Import and Export WizardIn your start menu SQL Server section you have a program which makes connections to both schemas and transfers the data between them with a wizard. Easy!

Need help in designing database schema

26 Oct 2016 by Vivek S Kale

Hii have a system "x" which has some promocodes, when user logs in to system x, then SMS is sent to user with unique promocodeSystem x has some 3rd party app when user trys to register or login to that app using promocodeThen 3rd party system registers user or it authenticates it and...

SQL-Server-2008R2

How to use xsd 1.1 in visual studio 2010

19 May 2017 by Balram Awasthi

How to validate xsd 1.1 in Visual Studio 2010 Error : The...

How to use xsd 1.1 in visual studio 2010

19 May 2017 by Dave Kreskowiak

You don't. XSD 1.1 isn't supported. In order to use it you need either a 3rd party library, none of which are cheap or free, or write your own support for it, which isn't trivial.

Schema form "fieldset" is not generate in schema form tag

15 Aug 2017 by rajshekhar yadav

i am working on schema form angular js mvc application,want to generate a form or template using json schema but its not working in my application , i have inject a "Schema-Form" in my controller and form tag with schema but its does not work ,also include js file for schema forms....some time...

Merge two XSD files into a single xsd file.

7 May 2020 by TarunShrivastav

I Have two XSD schema files and i want to merge them into a single XSD and then want to apply some transformation. What I have tried: I am able to merge these files with the below lines but facing issues with the Root element.

How to compare schema and data of two different databases

3 Oct 2018 by #realJSOP

Getting a schema for an entire database (which I seriously doubt is what you really want) requires quite a bit of planning and code, especially if you also want to get all of the related database components associated with that database. The answer to your question is WHOLLY outside the scope of...

synchronization

I made a scheme interpreter and I have a problem while displaying errors?

22 May 2020 by csvrn80

I implemented a Scheme interpreter.Everything is working fine but i couldn't manage to print error message.I declared a procedure named cs305 which will start the show when called. It don't takes any arguments and it shouldn't. In every iteration...

How to validate json string and schema C#

29 Jul 2020 by Member 14779968

I am using Newtonsoft library JSchema to check schema of a json response. but my check is coming back false. I have created a class with the objects present in the API json response and then generated the class object to schema using...

How to validate json string and schema C#

29 Jul 2020 by OriginalGriff

If I run your JSON through a class generator (I use Convert JSON to C# Classes Online - Json2CSharp Toolkit[^]) it does say it's invalid: and it is. Your API is returning bad JSON - specifically, this line: "id" : 2 requires a terminating comma....

How do i...validate a json using the path response schema in an open API schema where the schema has a $ref (potentially recursively)

21 Dec 2020 by j11codep

Validate a Json using the Path Response Schema in an Open API schema where the schema has a $ref (Potentially recursively) I'm trying to accomplish something along the lines of: //HttpClient call to the /pet/{petId} endpoint with Get verb here...

Avro.avroexception: genericrecord required to write against record schema but found avro.generic.genericrecord

10 May 2021 by rkganapathy

I got the exception from confluent Kafka producer like Avro.AvroException: GenericRecord required to write against record schema but found Avro.Generic.GenericRecord \n at Avro.Generic.DefaultWriter.EnsureRecordObject(RecordSchema s, Object...

How can I find a project that compares schema of 2 SQL server databases

10 Dec 2021 by Slow Eddie

I need to compare my test MS SQL Server database schema to the "Live" database. I have made major changes to a small part of my program, and I don't remember if I added changed any Stored Procedures or Table definitions. What I have tried: I...

How do I only allow a specific email address to register

9 Jan 2023 by K67987

This is my schema, how would I allow only specific email to register. For example, only people with an email address ending in gmail.com can register import mongoose from "mongoose"; const UserSchema = new mongoose.Schema( { name: {...

How do I only allow a specific email address to register

9 Jan 2023 by OriginalGriff

Try simplifying your regex: ^[a-zA-Z0-9_.+-]+?@[a-zA-Z0-9-]+?gmail\.com$ If you are going to use regular expressions, you need a helper tool. Get a copy of Expresso[^] - it's free, and it examines and generates Regular expressions.

Introduction to JSON Schema

13 Mar 2018 by Florian Rappl

JSON Schema may be the answer to most problems in dealing with JSON files. We explore JSON Schema from a practical point of view.

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

Schema for Transparent Xml Tags

1 Nov 2012 by Henning Dieterichs

Hello!I am working on a xml schema for a custom xml based template system. Similar to XSL, control statements like "foreach" or "if" are supported.But I got stuck to make the following xml snippet valid:

Excel add-in for XML schema XSD mapping

25 Sep 2012 by dashingly

Hi,I am new to the world of Office Add-Ins.Here is what I am trying to do:I would like to create an add-in that will:1. Read column names of an open excel document (xls, xml, csv, etc).2. Read the fields of a provided XSD XML schema file.3. Map the fields to columns if they match...

Merge two XSD files into a single xsd file.

18 Sep 2017 by Graeme_Grant

A Google Search: merge XSDs[^] found this: java - How to merge more than one XSD file to one XSD file? - Stack Overflow[^] which has examples and points to these documents for further information: * Schema Component Reuse - "include", "redefine" or "import"[^] * Schemas That Use Other...

What happens when I alter a table of MS SQL server 2014

9 May 2016 by OriginalGriff

If you increase or decrease a column width, then every piece of data in the table has be be examined and expanded of contracted appropriately. This normally means that SQL will do an internal drop and recreate of the table, which is a time consuming process.Generally speaking, you don't want...

How do I merge xsd files

16 Mar 2015 by Member 11531090

How to merge or combine multiple xsd filesthere are 2 schema:e.g. 1. employee schema: empid, empname, deptid2. Department Schema: deptid, deptnamehow to merge in 1 company schema (should work as a foreign key)

Need Optimization in Database Design

3 Aug 2015 by Member 9129971

I have a table applied in two different approaches:GroupModule:Id, GroupId, ModuleId, Permission(varchar())1 1 1 View:true,Create:false,Delete:true,Edit:true2 1 2 ...

How do I create .NET class from xsd schema?

5 May 2016 by aliwpf

Hi there , i have two class like following :public class WebServiceLog { public string Name { get; set; } public int ID { get; set; } } public class RoleEditLog { public List OldMethods { get; set; } public...

XML schema validation

24 Sep 2012 by Member 4029130

Thank you for the response, very interesting will give it a try at a later date. I have managed to resolve this by forcing what was actually 3 differing namespace to the appropriate structures of the XML doc. The overall root namespace had been overriding all others on the XSD until I removed...

converting from access to sql

19 Jun 2013 by Member 10114688

in access, OleDbConnection con=new OleDbCollection();con.Open();DataTable schTable=con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new Object[] { null, null, null, "TABLE" });how can write similar code for sql?

converting from access to sql

19 Jun 2013 by Christian Graus

There are articles on this site that show how to get a DB schema from SQL Server in C#. I tried embedding a link, but the page kept freezing, so you'll need to look for it.Code that has to work out the DB schema, always makes me nervous. I cna't think of a good reason to connect to a DB...

cny70 and schmitt trigger

8 Sep 2013 by Member 10260331

Hello,i would like to use a cny70 in combination with a duemilanove arduino to read a gasmeter in my house.I did some testing but got a poor signal change, now i am thinking that, in order to get a 1 or 0 signal, using a schmitt trigger could do the job.I am a electronic newbie, so could...

Generate C# code using Schema file

3 Jul 2014 by RhishikeshLathe

I have schema file and need to generate C# class.What are the steps to generate C# code

Stephen Boissiere - Where is Part 3?

4 Mar 2015 by Member 11498921

Where is Part 3 of Stephen Boissiere Generate SQL Database Schema from XML?

How do I merge xsd files

22 Apr 2015 by Gokulprasad05

empid.xsd empname.xsd deptid.xsddeptid.xsd ...

Authentication system Database design

2 Aug 2015 by Member 9129971

My Database Groups:GroupId,NameModules:ModuleId,NameModulePermissions:ModulePermissionId,ModuleId,PermissionValue,PermissionKeyApproach 1:GroupModule:GroupModuleId,GroupId,ModuleId,Permissions(varchar)Approach...

Authentication and Authorisation Database Design

2 Aug 2015 by Member 9129971

I am developing an Authentication and Authorisation System. Can you suggest me some good Authorisation and Authentication System Database Design.

How to compare schema and data of two different databases

3 Oct 2018 by Muhammad Hashir Abid

how to compare schema and data of two different databases and synchronize the latest changes in target database through c shrap Code. Note: i'm working on Desktop Application with Sql Server 2014 Explanation: i'm working with Desktop application on visual studio 2013 and sql server 2014. i want...

synchronization