Click here to Skip to main content
15,305,430 members
Home / Discussions / Database
   

Database

 
QuestionTransferring SQL Express data Pin
hairy_hats24-Aug-09 0:07
Memberhairy_hats24-Aug-09 0:07 
AnswerRe: Transferring SQL Express data Pin
Henry Minute24-Aug-09 0:29
MemberHenry Minute24-Aug-09 0:29 
GeneralRe: Transferring SQL Express data Pin
hairy_hats24-Aug-09 0:36
Memberhairy_hats24-Aug-09 0:36 
GeneralRe: Transferring SQL Express data Pin
Henry Minute24-Aug-09 5:51
MemberHenry Minute24-Aug-09 5:51 
QuestionDatabase design questions Pin
Saksida Bojan23-Aug-09 22:51
MemberSaksida Bojan23-Aug-09 22:51 
AnswerRe: Database design questions Pin
Mycroft Holmes23-Aug-09 23:34
professionalMycroft Holmes23-Aug-09 23:34 
GeneralRe: Database design questions Pin
Saksida Bojan23-Aug-09 23:51
MemberSaksida Bojan23-Aug-09 23:51 
AnswerRe: Database design questions Pin
N a v a n e e t h24-Aug-09 6:33
MemberN a v a n e e t h24-Aug-09 6:33 
Saksida Bojan wrote:
Is Xml Good for large databases?


What do you mean by that? Keeping all data in XML format? If yes, it is a bad idea.

Saksida Bojan wrote:
Shoud i use XmlDocument or XmlReader and XmlWriter?


I am not sure that these 3 classes can be compared as each of them serves different purpose.

XmlDocument is an in-memory DOM representation of the XML and other two are used for reading and writing. If you want to persist the XML in memory and need to manipulate it(querying with XPath etc..), choose XmlDocument. XmlDocument can also make the data editing and writing easy. If you have a custom data structure that has to be created/persisted to XML, prefer XmlReader and XmlWriter.

Saksida Bojan wrote:
If i chose XmlReader and XmlWriter how would i manage to quickly delete data?


Use XmlDocument in such case and call its Save() method for writing to XML file.

Saksida Bojan wrote:
Is it good to connect to remote server(MySQL) using .NET Connector?


No - if it is a stand-alone application. Wrap the database access behind a web service/WCF.

Saksida Bojan wrote:
I Also thinking of creating server app that will be on server betwen mysql and Client.
Is TCP good protocol or shoud i consider UDP. Currently i am reading about TCP and i am thinking if i should send XML data through TCP.


This is exactly what a WCF or web service layer does. WCF uses TCP communication and web services uses SOAP messages.

Smile | :)


GeneralRe: Database design questions Pin
Saksida Bojan24-Aug-09 7:28
MemberSaksida Bojan24-Aug-09 7:28 
GeneralRe: Database design questions Pin
N a v a n e e t h24-Aug-09 16:56
MemberN a v a n e e t h24-Aug-09 16:56 
QuestionOracle Equalent for Systypes and Syscolumns... Pin
sandhya1423-Aug-09 22:48
Membersandhya1423-Aug-09 22:48 
Questionget all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy23-Aug-09 18:26
MemberAbdul Rahman Hamidy23-Aug-09 18:26 
AnswerRe: get all parent tables name with child from sql 2005 Pin
Mycroft Holmes23-Aug-09 19:34
professionalMycroft Holmes23-Aug-09 19:34 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy23-Aug-09 20:23
MemberAbdul Rahman Hamidy23-Aug-09 20:23 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Mycroft Holmes23-Aug-09 21:19
professionalMycroft Holmes23-Aug-09 21:19 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy24-Aug-09 1:57
MemberAbdul Rahman Hamidy24-Aug-09 1:57 
QuestionStoring data which in the form of a list to database. Pin
udaykatakam21-Aug-09 8:04
Memberudaykatakam21-Aug-09 8:04 
AnswerRe: Storing data which in the form of a list to database. Pin
Mycroft Holmes21-Aug-09 17:18
professionalMycroft Holmes21-Aug-09 17:18 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam23-Aug-09 21:32
Memberudaykatakam23-Aug-09 21:32 
GeneralRe: Storing data which in the form of a list to database. Pin
Mycroft Holmes23-Aug-09 21:48
professionalMycroft Holmes23-Aug-09 21:48 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam24-Aug-09 11:29
Memberudaykatakam24-Aug-09 11:29 
QuestionAbout the SQL Execution Plan Pin
mctramp16820-Aug-09 22:09
Membermctramp16820-Aug-09 22:09 
AnswerRe: About the SQL Execution Plan Pin
Ashfield20-Aug-09 23:19
MemberAshfield20-Aug-09 23:19 
AnswerRe: About the SQL Execution Plan Pin
Mycroft Holmes21-Aug-09 0:38
professionalMycroft Holmes21-Aug-09 0:38 
GeneralRe: About the SQL Execution Plan Pin
David Mujica21-Aug-09 2:54
MemberDavid Mujica21-Aug-09 2:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.