Relational Tables Are Not Relational After Exported From My Sql Server To Host Sql Server

Dec 25, 2007

hello,

I am beginner for asp.net and sql server. I used Sql server manegement studio full version and I exported my aspnetdb which was created by VS2005 to my host sql server. I have a question: 

relational tables are not relational no longer. I noticed that when I created database diagram. what is wrong by exporting?

thanks for your helps...

View 3 Replies


ADVERTISEMENT

Create A Relational Diagram From Non-relational Database

Aug 4, 2005

Hi all,
I am trying to create a diagram for our database, during the creating, I create some of the relationships which were not there(basically our original database is not relational database, that's why I am doing it)
So sometimes I have to chage data type in order to create a relationship for the coloumns in different tables. i.e. change char(16) to varchar(7) (I checked the field that make sure all the data in this field is <= 7 characters)

But when I saved the diagram, there is an error message that state:
Errors were encountered during the save process. Some of your database objects are not saved on your diagram.

'agent' table saved successfully
'VisitUSA' table
- Unable to create relationship 'FK_VisitUSA_agent'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_VisitUSA_agent'. The conflict occurred in database 'CMC', table 'agent', column 'AgentCode'.

What does that mean? is it caused by some of the agentcode data in VisitUSA table which is not in agent table?
Thanks!
Betty

View 3 Replies View Related

Designing Relational Tables

Sep 22, 2007

Hi, not sure if this is the right forum for this question.
 I am creating relational tables for the first time in sql server express. I will have an orderItems table and an orders table. the MenuItems table is the problem. It is a catalogue of books. There will be about ten columns. all are unique to each book. i.e isbn number, title, author, publisher etc. but ten columns seems to be quite cumbersome. it may be easier to break the table down into two tables (i.e. primary details and secondary details perhaps) However to populate the table in the first place it would be easier to have it as one table instead of opening and closing 2 tables Adding the odd book to the two tables in the future would not be a problem. so the question is can i create a table and then brak it into two relational tables afterwards. If so how do i do this. this is my foirst go at relational tables and i am still trying to get a handle on visualising them. If my logic is up the wall please let me know....
Nick

View 2 Replies View Related

Insert On Relational Tables

Apr 7, 2008

I understand the basics for doing an insert. Their seems to be many ways of achieving the same thing in .net. I have used the tableadpaters and sqlcommand functionality to achieve this. My one question is how foregin keys should be created in associated tables. EG so if i create a new record entry in one table and the primary key for that entry is a foreign key in another table, do I need to call 2 table adapters, or run 2 sqlcommands(taking the primary key from the first traction and use this in the next transaction)?

Any help or direction for some good tutorials on this would be much appreciated.

Thanks

Mark

View 4 Replies View Related

What Are The Properties Of The Relational Tables?

Mar 4, 2008



Hello friends .....What is the answer for this question in frame of SQL 2005 Management Studio or SQL Server 2000 ?

What are the properties of the Relational tables?

View 1 Replies View Related

Need To Insert Data Into 2 Tables, Relational Having Problems

Mar 7, 2007

Ok, I have a page on my website where we can add products to our database.  We are a music store, and most products have different versions or colors.  I've created 2 tables, Products and Subproducts.  The products table may hold info like Fender Stratocaster, and the subproducts would hold colors (Blue, Sunburst, etc).  The subproducts table has an integer field called MainProductID, which is linked to the mainproducts table field RecordID. So far the page uses a wizard where if first creates the main product using an sql datasource.  After the data has been added to the main products table, my page gives you the opportunity to add different sub products.  The problem I am having is actually feeding in the RecordID from the main products table to my insert parameter on the sub products data source.  This is what I have tried so far: There is a formview on the page that is bound to the main products table, after the entry is created I can physically see the info on my screen, so I know the data is there at my disposal SubProductsDataSource.InsertParameters.Add("@MainProductID", Formview1.datakey.item("RecordID"))SubProductsDataSource.Insert()Using this adds the data to the table, but the MainProductID is nullalso is there a cheap little way to refresh a page, because when I upload the product images I have it go to the next step where you are supposed to be able to see the images you uploaded, I don't see them which makes me think that the page is loading faster than the images are uploading.  Thanks   

View 1 Replies View Related

Insert/Update Relational Tables Using Dataadapter

May 2, 2008

Hi!

I am trying to insert data into 2 different tables. I am using dataadapter and dataset.

Protected Sub SubmitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubmitButton.Click
Call ConnectionString()

Dim insertSQL As New SqlCommand()
insertSQL.Connection = sqlConn
insertSQL.CommandText = "SELECT location.CountryName, location.CityName, location.BuildingName, location.FloorID, rooms.name, rooms.FloorID AS Expr1 FROM location INNER JOIN floors ON location.FloorID = floors.id INNER JOIN rooms ON floors.id = rooms.FloorID"

Dim ds As New DataSet()
Dim da As New SqlDataAdapter()

da.SelectCommand = insertSQL
Dim scb As New SqlCommandBuilder(da)

Try
da.Fill(ds)
Dim ndr = ds.Tables("location").NewRow
Dim ndr2 = ds.Tables("rooms").NewRow

ndr("FloorID") = FloorIDDDL.SelectedValue
ndr("CountryName") = CountryNameTextBox.Text
ndr("CityName") = CityNameTextBox.Text
ndr("BuildingName") = BuildingNameTextBox.Text
ndr2("name") = RoomNameTextBox.Text
ndr2("FloorID") = FloorIDDDL.SelectedValue
ds.Tables("location").Rows.Add(ndr)
ds.Tables("room").Rows.Add(ndr2)
da.Update(ds)
ErrMsgLbl.Text = "Information saved successfully"
Catch ex As Exception
ErrMsgLbl.Text = ex.ToString
End Try

sqlConn.Close()
End Sub

The above code does not throw any error. It also does not update the tables.

Your help will be appreciated.

Thanks!

View 5 Replies View Related

Union Two Tables With Relational Ordering / Grouping?

Jul 16, 2012

I have two tables with data that I need to get and display in a combobox. What I want to do is have the parent table listed in the combobox with all of its children indented. Sorted by parent then by child.

This SQL seems to be more complex than I have done previously

I can get all of the records from both tables easily:

Code:
SELECT strName, ID FROM tblParents as pp
INNER JOIN tblChildren as cc
ON cc.pID = pp.uiGUID
UNION (SELECT strName FROM tblChildren as c
INNER JOIN tblParents as p
ON c.pID = p.ID)

However, this simply returns a list that is not ordered in any fashion. I'd like to have all of the parent's children shown under the parent name (there is only 1 parent per child and multiple children per parent)

View 2 Replies View Related

Guidance Needed: Loading Hierarchical XML Into Relational Tables

Aug 8, 2007

I've got a lot of XML like this (simplified):




Code Snippet





... 8 MORE


... 9 MORE TIMES






I need to get this into three existing SQL Server 2005 tables, each with identity columns for their primary keys:




Code Snippet
CREATE TABLE ELEMENT1 (

[ID] INT IDENTITY
)

CREATE TABLE ELEMENT2 (

[ID] INT IDENTITY,
[ELEMENT1_ID] INT
)

CREATE TABLE ELEMENT3 (

[ID] INT IDENTITY,
[ELEMENT2_ID] INT
)





With primary and foreign keys as you'd expect, and, of course, many more columns!

How would I get this into tables through SSIS, preferably in a high-performance manner (there may be several gigabytes of XML to load).

The issue, of course, is that in order to insert an ELEMENT2 row, I need the ID from the coresponding ELEMENT1, etc.

Any ideas or pointers to articles would be welcome.

View 14 Replies View Related

SQL XML :: Shred To Relational Tables - Creating Foreign Keys

Oct 7, 2015

I'm shredding the below xml into relational tables. Each element of the xml has it's own table and there is a foreign key to join the tables, you can see this in the below picture. The process I follow is each relational table I always bring the nesecary xml and store it in the table and when shredding I always look at the parent table.So for example when processing the seat table, I use seat xml from the parent route table, also taking the ROUTEID from the route table. The reason I do this is all about taking the id from the previous step to create the relationships between the tables. without taking the xml down to the tables?The problem with this approach is I have xml stored in most tables and the tables are becoming very large.

<Route Type="OneWay" >
<Seat Type="FirstClass">
<Prices>
<Price Price="10" />
<Price Price="11" />
</Prices>

[code]....

View 4 Replies View Related

Storing SQL Server Agent Logs In A Relational Store

May 29, 2006

Hi,I want to store the SQL Server Agent logs into a table. I was able toread SQL server errorlogs using sp_readerrorlog and store the data intoa table successfully.I want to do the same for SQL Agent logs. options?Thanks in advanceThyagu.

View 1 Replies View Related

Relations Does Not Work After I Exported SQL Server DB To My Host

Jul 19, 2005

Hi,after i exported my DataBase From my local computer to host, all tables and views have exported, but my tables Realations dosent exported and i have'not any realation in my database, i can't create new realation , when i want to do this i get an error:" You do not have sufficient privelege to create n new database diagram" What this mean??how i can export my database to my host whit my realations?plz help me i you can!thanks.

View 6 Replies View Related

Relational Databases

Oct 3, 2007

I have a membership database and a profile database with a userid column in both.  The foreign key is in the profile database where i want a persons profile details to go like location,occupation and what not.  How do I make it so when a new user registers a userId is created in the profile database that matched the userid in the membership database so i can query out profile details based on a registered members userid?

View 6 Replies View Related

Help With Relational Query - Many To Many

Jun 21, 2005

Hi all! I am working on a piece of SQL at the moment and I'm getting a little confused. I have 3 tables: Items, Attributes and a table linking them. I have 5 attributes and an item can have any of the 5 attributes. So my linking table holds the ItemID and the AttributeID and there can be 1-5 entries for each Item. A user can search for items based on Attributes; so they can tick 5 checkboxes that represent the 5 Attributes. So I need to build a query based on their choices. At the moment I'm using:Select * FROM ItemsINNER JOIN linking on Link_ItemID = Item_IDWHERE Link_AttributeID IN (10, 13, 17)But this brings out the Item that have either AttributeID of 10 or 13 or 17 whereas I need it to pull out ONLY items that have a AttributeID of 10 AND 13 AND 17.Can anyone help with this query? Sorry if this is badly worded. The solutions is prolly something really simple I have overlooked... :SI've also tried:Select * FROM ItemsINNER JOIN linking on Link_ItemID = Item_IDWHERE Link_AttributeID = 10 AND AttributeID = 13 etcBut obviously that won't work! :s

View 2 Replies View Related

Relational Database

Apr 22, 2006

Hi
 
I'm using  VB.NET,ADO.NET in ASP.NET .
 
Microsoft .Net framework 1.0 
 
Windows 2000
 
Visual Studio IDE
 
and SQLServer.
 
I have to create to tables as
 
Table1 contains ID,Name
Table2 contains ID,Marks,Foreign Key ie Primary key of the table Table1.
 
Give me an information how to create these two tables in SQLServer (I know how to create a table but i don't know how to create a table which includes Foreign Key.)
 
Then using Dataset i want to display the records as Name,Marks which are stored in two tables.
 
I have studied that in ADO Join query and record set object is used but it gives a problems and it is not good when we want to transfer the data between two applications or pages but dataset solves all those problems.
 
Give me an information about it.
 
Kindly help me
 
Thanks in advance
 
Regards.

View 3 Replies View Related

Relational Databases

Jun 18, 2001

what is the difference in making relational databases in SQL vs. Access? Do you need to make them if you will be using ColdFusion? What do the other fields in minor tables need to be in order to connect them to a major table when it will all be based on a number that is in the major table? i'm kind of confused on this issue...Thanks!

View 1 Replies View Related

Relational Design

Nov 10, 2004

I have a database with 3 tables in a many to many relationship.

EmployeeGamingLicense
EmployeeDocuments
EmployeeRenewals

I created the third table to hold the employeerenewal dates, I did this because I cant have repeating vaules in the primary table. I am just making sure that my course of action is the correct one. The purpose of the Employeerenewals is to give the users an indication that a certain renewal has been processed, because in the past there was several hundred that were not processed. The problem was that the users had no way of knowing this. What I was thinking was having the primary table calculate a renewal date based off the finalsuit and show the results in the Employeerenewals with a yes of no drop down. Now the yes or no drop down box will be give the users their red flag if the renewals have been processed or not.

Does that make sense??

Thanks guys :)

View 1 Replies View Related

Relational Databases

Sep 4, 2006

Hi
I am developing a website current and i have a database that seems to be growing very rapidly..
I would like to ask if anyone knows of any good tutorials/examples on relational databases?
Also does anyone know of any good database design tutorials/examples?

If it helps i am using Microsoft Visual Web Developer

Thanks

If you think you know it all?! You know nothing!

View 3 Replies View Related

Relational Database

Apr 26, 2007

If I have a table that contains default values or a constant values do I have to relate it to my other tables that might need them. Thanks in advance.

===============
JSC0624
===============

View 2 Replies View Related

A Many-to-many Relational Problem

Jun 15, 2007

My question:
How to have an unknown number of authors returned for a list of books, with the multiple authors being returned on the SAME row as each book

My table structure:

Table A - Books
-------------------
BookID | BookName
-------------------
1 | Book One

Table B -
RelatingTable
-------------------
BookID | AuthorID
-------------------
1 | 60
1 | 61

Table C - Authors
-------------------
AuthorID | AuthorName
-------------------
60 | Bob
61 | Joe


My query:

SELECT * FROM Books, RelatingTable, Authors AS a
INNER JOIN Books AS b ON b.BookID = r.BookID
INNER JOIN RelatedTable AS r ON r.AuthorID = a.AuthorID


Output I am getting:

-------------------------------------------------------------------------
b.BookID | b.BookName | r.BookID | r.AuthorID | a.AuthorID | a.AuthorName
---------|------------|----------|------------|------------|-------------
1 | Book One | 1 | 60 | 60 | Bob
1 | Book One | 1 | 61 | 61 | Joe
-------------------------------------------------------------------------


Desired output:

-----------------------------------------------------------------------------------------------------------------------------------------------------
b.BookID | b.BookName | r.BookID[0] | r.AuthorID[0] | a.AuthorID[0] | a.AuthorName[0] | r.BookID[1] | r.AuthorID[1] | a.AuthorID[1] | a.AuthorName[1]
---------|------------|-------------|---------------|---------------|-----------------|-------------|---------------|---------------|----------------
1 | Book One | 1 | 60 | 60 | Bob | 1 | 61 | 61 | Joe
-----------------------------------------------------------------------------------------------------------------------------------------------------


The desired output does not have to be like an array - I only assume thats what it would need to be

If you can post anything to help me get in the right direction I would really appreciate it
Thanks for your time!

View 11 Replies View Related

Relational Database

Feb 16, 2006

Hi,I have a very simple question.In what cases are relational databases necessary?Are they really necessary in cases where only asingle type of query is to be performed based on one uniquefield or can we just put all fields together in a single databaseand just access them through that unique field?

View 6 Replies View Related

Relational Model And XML

Jul 20, 2005

Hi,This question has been bothering me for some time. A lot of peopleseem to "think" XML is the king of data problems, and I've heard thatnext version of SQL Server is going to have a strong XML flavor,meantime, I seem to get the impression that a large number ofhard-core relational model gurus do not seem to be that impressed withXML (technical value of this extra layer seems to be limited whilebusiness value might be substantial for instance, more software work,more disk space requirement etc. etc.). What's your take on this?Generality or specifics, all welcome. One specific question is, howcan XML supplement relational model?Thanks.

View 12 Replies View Related

SQL - Relational Database

Jun 27, 2007

Hi guys,

What is a "Relational Database"?

Thanks,

Aldo.

View 1 Replies View Related

Relational Data And RDA

Aug 1, 2006

I have a few questions for you guys. I have a client
application that can be offline or online. While offline, records can be added and need to be later synced to production.


I will use rda to pull the table down, and this is working fine. Now what if I
have multiple tables where I want a foreign key relationship?

With rda I can only pull down one table at a time from
everything I've read. Now say create a constraint after pulling the two or more tables down. While in offline mode I create a new record on two seperate tables with foreign key/primary key relationship.



When I do the push to the server will it automatically
update the foreign key reference (locally) to the right one on the production
server? Or will I get a duplicate primary key error? On the production server the primary key will be different because of the identity. This is very important because I will have multiple clients.

Thanks in advance

View 1 Replies View Related

SQLDataSource Relational Data

Nov 14, 2005

I am just now starting the switch from .NET 1.1 to .NET 2.0.  I really like the new way of using the SQLDataSource and setting up Views declaratively as opposed to doing it all in code, which brings me to my question.In some of my applications I have a single Stored Procedure return multiple result sets to a single DataSet where I have a DataRelation set up.  Then I can have nested DataGrids that use the GetChildRows() method to filter the results to display the hierarchical data.  I would like to do something similar with the SQLDataSource and GridViews but haven't found a way to get multiple result sets.One thought I had was to create a Strongly Typed Dataset and then use the ObjectDataSource object, but I still didn't see a way to get child rows out of the datasource.  I've seen an example that uses a <FilterParameter> to get nested data, but there is an extra trip made to the server for each parent item as it just put an extra parameter in the WHERE clause of the query.

View 1 Replies View Related

OLAP Relational Structure

Sep 28, 2005

I am building a data warehousing solution without using analysis services or OLAP or OLTP....

Dont ask why ... but I have to....


Ok so which table structure would be better ?


dimention 1|dimention 2|dimention 3|matrix 1|matrix 2|matrix 3|matrix 4....


or


dimention 1|dimention 2|dimention 3|matrix name|matrix value



I prefer the second one....

View 14 Replies View Related

Converting Relational Data In XML??

Apr 2, 2008

Hello everyone

When converting From Relational data into XML which
method ie RAW, AUTO, PATH, EXPLICIT is mostly used and why please

Regards

Rob

View 5 Replies View Related

Relational Algebra Question

Apr 24, 2007

This is a bit of a trivial question, since I know how to actually create the code in SQL. Hope this is the right section to post it in too, since it sort of concerns design I guess..

My problem is how to I represent the following SQL query in relational algebra:

SELECT *
FROM Staff;

Since I'm using SELECT, I assume I use selection to represent it, so would it be as "ó(Staff)" [using the sigma symbol, in case it doesn't show]? But as I'm not specifying a predicate since I wish to select all fields in Staff, would it be simply represented as "Staff"?

I appreciate any help... it's been baffling me for a while

View 2 Replies View Related

Query Help Please (relational Algebra)

Dec 12, 2007

Hotel(hotelno, hotelname ,city)
Room(roomNo, hotelNo,type,price)

i need the reltional algebra to list the price and type of rooms in the hilton hotel
thanx

View 5 Replies View Related

Relational Data Transfer In DTS

Jul 20, 2005

Hi Please help for this simple problemDTS Transfer or any other method?I have Customer_Order Table and customer_Order_Details Table.For OrderID = 1, I have 3 rows of Order Details.I want to transferCustomer_Order Table for OrderID 1 in DTS, the system should transferOrder Table as well as Order details table Rows for ORderID =1.How to customize in DT or is there any way to get this data to transferfrom source DB to Dest DB?KAMAL KUMAR V--Posted via http://dbforums.com

View 1 Replies View Related

How To Extract Json From Relational DB

Jul 3, 2013

Is there a good, common way to migrate data from relational tables into hierarchical json?

I am asking this because, basically, I prefer not to write a lot of procedural code.

I am currently working with MS SQL Server db and I’ll soon need to do the same with My SQL db. I use java and java db connectivity for access. It would be great if any of these two db’s can somehow assemble the data server-side.

View 4 Replies View Related

Error While Trying To Get Predictions From Relational DB

Sep 21, 2006

I am trying to get predictions and insert them into a DB table.

Following is the code I am using , but I am getting an error saying

'

An error occurred while preparing the query

,

Pl. help.

begin

declare @v_query varchar(5000);
declare @full_query varchar(5000);
declare @v_dbquery varchar (200);

set @v_dbquery = char(39)+'SELECT
[ProspectAlternateKey],
[FirstName],
[LastName],
[MaritalStatus],
[Gender],
[YearlyIncome],
[TotalChildren],
[NumberChildrenAtHome],
[HouseOwnerFlag],
[NumberCarsOwned]
FROM
[dbo].[ProspectiveBuyer]'+char(39);

set @v_query = 'SELECT
[TM_Cluster].[Bike Buyer],
t.[ProspectAlternateKey],
PredictProbability([TM_Cluster].[Bike Buyer])
From
[TM_Cluster]
PREDICTION JOIN
OPENQUERY([Adventure Works DW],@v_dbquery) AS t
ON
[TM_Cluster].[Marital Status] = t.[MaritalStatus] AND
[TM_Cluster].[Gender] = t.[Gender] AND
[TM_Cluster].[Yearly Income] = t.[YearlyIncome] AND
[TM_Cluster].[Total Children] = t.[TotalChildren] AND
[TM_Cluster].[Number Children At Home] = t.[NumberChildrenAtHome] AND
[TM_Cluster].[House Owner Flag] = t.[HouseOwnerFlag] AND
[TM_Cluster].[Number Cars Owned] = t.[NumberCarsOwned]'
-- print @v_query

set @full_query = 'select * from openquery (DMserver,'+char(39)+ @v_query +char(39)+')' ;

print @full_query;

EXEC (@full_query);


end

View 4 Replies View Related

Mining Cubes Vs Relational

Nov 21, 2006

I've not found much guidance so far about the pros and cons of mining OLAP cubes vs their underlying fact and dimension tables. Can anyone offer advice in this area, or point me to more info about this?

Thanks,
Kevin

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved