StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>First of all, write your class to wrap all this calls for different databases. Probably you will use the data providers provided by the database to connect to each one.</p> <p>This driver, provides a series of classes to work with the databases, using ado.net. Use this classes on your wrap class, to import/export the data. Normally this data providers have a way to map the database type to .net clr types.</p> <p>And, you have to discover the key points for each database, for example: Where the database in question stores information for table, table fields, indexes, keys.. </p> <p><strong>EDIT:</strong></p> <ul> <li>Read the table in the database storing his information and information of the fields for that table(field names, type, length, etc)</li> <li>In this class that you will write to store this table info, create a field for store the clr type too (like i said before, this data providers provide a way to map the database type to .net clr type)</li> <li>Ok, now you have the table info, respecting the characteristic for each database.</li> </ul> <p>Now, you can start your import/export operations.</p> <p>For example, supposing you are reading from oracle and writing into sql.</p> <ul> <li>You read the table info for that table.</li> <li>Read the data from the table(select) and stores on an datatable</li> <li>Now, all you have to do is an insert into sql table, using of course, the data readed from oracle.</li> <li>And remember the info that you got for the table? You need to respect the type mapping for each database.</li> </ul> <p>See:</p> <p><a href="http://technet.microsoft.com/en-us/library/ms151817.aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/ms151817.aspx</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload