|
I have an ASP .NET application that connects to an Oracle or a SQL Server database. An installer has been developed to install a fresh database to an existing SQL Server using sql commands such as "restore database..." which simply restores a ".bak" file...
Started by Carl on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
More recently (2007), I scripted the creation of an Oracle 10g database that I was originally hired to lead its conversion from a SQL Server database to an Oracle databaseThe question is -- what do your....
Stuff instead).
|
|
On Wed, 15 Apr 2009 23:50:35 -0700 (PDT), Veeru71 <m_adavi@hotmail.com
We need to replicate (1-way) a bunch of tables from Server-A to
Server-B in close to real-time.
Server-B is located in a foreign country.
Apporx. # of tables to be replicated...
Started by Veeru71 on
, 6 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
If the requirement is "near-real-time", the question is how near to
real-time does it need to be? seconds? minutes? hours?
Once the tables are duplicated, you need to worry about how much data
per second that is proscribed (no password....
|
|
On Sat, 18 Apr 2009 10:53:27 -0500, "Bob Jones" <email@me.not
"Veeru71" <m_adavi@hotmail.comnews:1b53dd4e-96fa-452f-b7bd-1f49c87a255d@v23g2000pro.googlegroups.com...
Basic replication is the easiest solution. Just have everything set up on ...
Started by Bob Jones on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
You
also have....
I've done will be a problem.
The change log is
deleted once all the changes are committed .
In such cases, the changes should some how
get queued and applied the changes to database B.
With Server-
B or the network, etc.
|
Ask your Facebook Friends
|
On Sun, 19 Apr 2009 23:34:33 -0700 (PDT), Murty <m_adavi@hotmail.com
Thanks for you all your responses....Here are some more details.
1) Near real-time <--
2) Server A can have DB Link to Server B (But the other way is
prohibited)
3) We ...
Started by Murty on
, 10 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Then again, all you're doing is reinventing fast-refresh to A? The DB link owner can have ... .
The change log is
deleted once of the batch process on your A database.
Minutes, reading the
changed rows and pushing the changes to database B.
|
|
How to design a database that supports a feature that would allow the application user to create a snapshot of their data at a point in time, a bit like version control.
It would give the user the ability to go back and see what their data looked like...
Started by saille on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
SQL Server 2005 (onwards) Enterprise Edition has the ability to create Database snapshots
Oracle from version 9i have Flashback technology, which is in Oracle 10g and 11g much improved and you can then "play-back" those logs....
|
|
Hello Guys
As per oracle docs
The new archive redo log format in Oracle Database 10g is of the following form:
LOG_ARCHIVE_FORMAT = 'log%t_%s_%r.arc'
Flash recovery area by pass defined LOG_ARCHIVE_FORMAT and impose its own archive log format
i seen in...
Started by 804719 on
, 15 posts
by 6 people.
Answer Snippets (Read the full thread at oracle):
You only can define a second destination If I remember correctly, FRA... .
Sharma yes FRA is using OMF(oracle managed file names),but can i replicate same format for archive logs;/<Oracle_Managed_File_Name>
You cannot change that.
|
|
Hi all ,
I'm recently completed stream tables level configuration one direction -- source and destination schema same
my question is can i configure stream replication from source database with schema name different to the schema destination like
can ...
Started by user11969912 on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at oracle):
But, I noticed that the DDLs will not be replicated in Oracle 10g when you use a different schema name note:
How to TRANSFORM a Schema Name in Streams using Declarative Rule Transformations [ID 784126.1.
|
|
Hi,
We're about to run side-by-side testing to compare a legacy system with a new shiny version. We have an Oracle database table, A, that stores data for the legacy system, and an equivalent table, B, that stores data for the new system, so for the duration...
Started by Andy on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
How tight does the synchronization between tables....
You can see here for some info.
SELECT * FROM B WHERE B.PRIMARY_KEY = A.PRIMARY_KEY );
Oracle 10g and above have implemented Change install of Oracle 10g and above.
|
|
I enjoyed the answers and questions about hidden features in sql server
What can you tell us about Oracle?
Hidden tables, inner workings of ..., secret stored procs, package that has good utils...
Started by Peter Gfader on
, 18 posts
by 12 people.
Answer Snippets (Read the full thread at stackoverflow):
Since Apex is now part of every Oracle database (available for Oracle 10g and up)
Q: How to call a stored with a cursor from TOAD?
A: Example, change to your cursor....
For rolling your own replication mechanism.
|
|
On Fri, 6 Jun 2008 03:40:15 -0700 (PDT), kerravon <kerravon@w3.to
We have an Oracle 9 (soon 10) on Solaris 8 system located in
Australia,
and a backup system located in the US. Due to the speed of light,
there
is a 400 ms round trip.
Ideally we...
Started by kerravon on
, 8 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound....
By DA but with respect to your round trip time
have you tuned Oracle's use of TCP/IP?
Among
--
Daniel A.
|
