*
The moose likes JDBC and the fly likes Data migration from One SQL server to another SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Data migration from One SQL server to another SQL Server" Watch "Data migration from One SQL server to another SQL Server" New topic
Author

Data migration from One SQL server to another SQL Server

sandy patel
Greenhorn

Joined: Dec 13, 2008
Posts: 1
Hi,
I need your views or thoughs to do below stuff.

I have one real time database (production db) and another is backup database. There is 250 transaction happned per second on production db. So, I need all those transactions made available on another db as soon as possible after occurance.

Appriciate in advance.

Thanks
Sandip
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

You probably need to think cluster and the solution will be very vendor specific....


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
 
 
subject: Data migration from One SQL server to another SQL Server
 
Similar Threads
[Microsoft] [ODBC SQL Server Driver][SQL Server] cannot open database "bms" requested by the login.
Oracle DB Link to SQL Server 2000
hsqldb
How to get a blank ResultSet to do update?
Query Optimization