Oracle distributed databases and MSVC -

-

i using visual studio 2008 c# , sql development.

  • which oracle version should download? oracle 10g?

  • does have design interface sql server mangement studio?

  • will distribution concept have graphical tool "hi, on servers distributed database , on basis"?

  • using local application, when connect server , try enter or delete data not on server, oracle db management system transparently access other servers or insert data? or produce error?

in reverse order:

oracle not distributed in way (seem to) imagine. it's not voldemort or cassandra. it's 1 database per server, unless you're talking rac: rac shared everything, it's transparent (but way complicated).

the nearest oracle has sql server management studio is, guess, enterprise manager. suspect oem not easy use mssql counterpart.

if have free choice use 11gr2. why wouldn't not use latest version?

oracle support 1 application using multiple databases. however, due existing (even legacy) databases providing of data application. should not deliberately set out have separate databases on multiple databases, because distributed transactions slower, less reliable , harder tune. find out more.

if want have multiple servers resilience or scalability said before rac (real application clusters) oracle's solution. different architecture sql server's federated approach. find out more.

"so link thing support free versions of oracle?"

there 1 free (as in free beer) version of oracle, , express edition (currently still 10g only). edition support database links. suggest read 2 related articles lewis cunningham: 1 explaining db links , other on linking multiple xe instances.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more