Click here to Skip to main content
15,557,928 members
Home / Discussions / Database
   

Database

 
AnswerRe: Error Pin
CHill6031-Mar-15 13:36
mveCHill6031-Mar-15 13:36 
AnswerRe: Error Pin
Mycroft Holmes31-Mar-15 13:48
professionalMycroft Holmes31-Mar-15 13:48 
GeneralRe: Error Pin
Richard Deeming1-Apr-15 1:39
mveRichard Deeming1-Apr-15 1:39 
QuestionConvert msaccess pivot to mssql pivot Pin
kdaras30-Mar-15 23:22
kdaras30-Mar-15 23:22 
AnswerRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 3:44
mveCHill6031-Mar-15 3:44 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
kdaras31-Mar-15 20:45
kdaras31-Mar-15 20:45 
GeneralRe: Convert msaccess pivot to mssql pivot Pin
CHill6031-Mar-15 21:43
mveCHill6031-Mar-15 21:43 
Questionretrieving index info Pin
loyal ginger30-Mar-15 10:39
loyal ginger30-Mar-15 10:39 
I am writing a utility to copy tables from one DB to another. This can be from MySQL, MS SQL Server, MS Access DB, or SQLite DB to another DB of one of the above types. The program handles any of the above combinations. For example, the user can choose to copy a table from MySQL server to an MS Access database. I am using ADO.NET to write this app.

Currently I create a DataReader using the query "Select * from ", and then call its GetSchemaTable() method to obtain the field info of the source table. This method returns a DataTable that contains each field's basic info such as field name, type, size, whether or not it is a key, etc. These allow me to do the data type match and create the fields in the target DB.

My question is how to obtain the source table's index info. The above DataTable object seems not sufficient for this purpose. Can you give me a pointer as to how this can be done? Thanks!
AnswerRe: retrieving index info Pin
Sascha Lefèvre30-Mar-15 14:07
professionalSascha Lefèvre30-Mar-15 14:07 
QuestionINSERT from with a loop using MySQL Pin
Jassim Rahma30-Mar-15 5:39
Jassim Rahma30-Mar-15 5:39 
QuestionOracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest29-Mar-15 23:32
KasGuest29-Mar-15 23:32 
SuggestionRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Kornfeld Eliyahu Peter30-Mar-15 0:43
professionalKornfeld Eliyahu Peter30-Mar-15 0:43 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest30-Mar-15 1:34
KasGuest30-Mar-15 1:34 
AnswerRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Eddy Vluggen30-Mar-15 1:57
professionalEddy Vluggen30-Mar-15 1:57 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
KasGuest30-Mar-15 2:29
KasGuest30-Mar-15 2:29 
GeneralRe: Oracle create database error: Error in process: C:\app\...\product\12.1.0\dbhome_1\perl\bin\perl.exe Pin
Eddy Vluggen30-Mar-15 2:39
professionalEddy Vluggen30-Mar-15 2:39 
QuestionGet a single record for each user Pin
Meax25-Mar-15 23:49
Meax25-Mar-15 23:49 
AnswerRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:17
mveAfzaal Ahmad Zeeshan26-Mar-15 0:17 
GeneralRe: Get a single record for each user Pin
Meax26-Mar-15 0:30
Meax26-Mar-15 0:30 
GeneralRe: Get a single record for each user Pin
Afzaal Ahmad Zeeshan26-Mar-15 0:36
mveAfzaal Ahmad Zeeshan26-Mar-15 0:36 
GeneralRe: Get a single record for each user Pin
Meax26-Mar-15 0:47
Meax26-Mar-15 0:47 
GeneralRe: Get a single record for each user Pin
RUs12326-Mar-15 1:42
RUs12326-Mar-15 1:42 
AnswerRe: Get a single record for each user Pin
Simon_Whale26-Mar-15 2:11
Simon_Whale26-Mar-15 2:11 
AnswerRe: Get a single record for each user Pin
Corporal Agarn26-Mar-15 2:16
professionalCorporal Agarn26-Mar-15 2:16 
AnswerRe: Get a single record for each user Pin
Member 1155935526-Mar-15 21:28
Member 1155935526-Mar-15 21:28 

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.