|
Where do you want the process to run? How often does it run?
Simple solution is to export the data from one server and then import it to the other. You can automate this process with some code.
More complex solutions involve specifics of each database. MS SQL Server has tool\system, "SQL Server Integration Service", as part of it which is basically designed for moving data back and forth. One can make this as complex as one wants.
MS SQL Server allows one to set up a ODBC connection and use it. So one could do it in SQL Server. Oracle might have something similar but I wouldn't go that route because setting up ODBC on unix variants is not only a problem but you would need to find a MS SQL Server ODBC driver as well. However, Oracle has a java VM built in so you could use a java only MS SQL Server jdbc driver and do a call like that.
However if it was me I would stay away from the internal solutions because getting everything to work right via permissions, loading, turning everything on, figuring out ports, etc will take more time than writing the code in the first place. So some solution that uses import\export is going to be less frustrating.
|
|
|
|
|
Then you need to create a database link.
If you want to control it from the SQLServer side you download and install the Oracle client.
Configure the client and verify connectivity to the Oracle server using Net Manager.
Create a linked server in SSMS using Microsoft OLE DB Provider for Oracle.
This is from memory and might be incorrect, but you should have enough info to google the correct procedure.
If you want to control the link from the oracle side you have a How-to here[^].
Be excellent to each other. And... PARTY ON, DUDES!
Abraham Lincoln
|
|
|
|
|
you can use ODBC connection
Masoud Nikoofar
|
|
|
|
|
INSERT INTO tbl SELECT x UNION SELECT y UNION SELECT z isn't valid Oracle not because of the UNION, but because of the SELECTs.
You could simply change it to INSERT INTO tbl SELECT x FROM DUAL UNION SELECT y FROM DUAL UNION SELECT z FROM DUAL
You could quickly do this manually with a search and replace UNION with DUAL UNION and add one DUAL on the end
|
|
|
|
|
I just looked at the database forum here on CodeProject, and its two related forums, and the definition of "database" in those three groups is way beyond the scope of what I'm looking for. Those guys look like the professionals of professionals.
I just want to set up a system that I can use to track a set of people. A spreadsheet is *NOT* the answer in this case. I want a window on my screen with the fields physically separated and so on; i.e., simple without requiring me to solve complex matrix algebra just to keep a list of names, E-mail, and some keywords associated with each member.
I seriously doubt that I'll ever have a thousand people in this system.
So far I have looked on
- FreeWareFiles.com
- FileHippo.com
- Download-Free.com
- Download.com
I welcome suggestions for such a database program.
Desirable features are...
-- Freeware
-- Easily set up
-- Ability to add a field in the future.
-- Short learning curve
Thank you for reading this.
Thank you for any and all suggestions.
[Ed. - Moved.]
modified 4-Oct-13 20:53pm.
|
|
|
|
|
|
C-P-User-3 wrote: to track a set of people
Can you elaborate on this? By "track" do you mean "find by email and/or keyword", or something else? Do you anticipate increasing the type of data of you may want to manage in the future (e.g. contact phone #, etc.)?
An old version of MS Access can be had for less than $20 - see this[^] EBay auction.
/ravi
|
|
|
|
|
Ravi Bhavnani wrote: An old version of MS Access
That's what I was going to suggest, they have some canned apps and one of them should fit the bill without to much extra effort if any!
|
|
|
|
|
Do you know how much it pains me to agree with you?
I'll still recommend sql server but that is only prejudice 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Silly question - have you considered Google Contacts?
It'll do most of what you want (If not all) already...
The only instant messaging I do involves my middle finger.
|
|
|
|
|
|
Sounds to me like you want something like FileMaker pro or maybe grubba[^]
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
Take a look at this[^] . It's a semi-auto generated data services for membership management. Once setup, it allows rapid and customized growth. It could serve your purposes (i.e. it have build-in SQL like, smart, user search interface so that you may not need keywords). It allows an initially small system to grow smoothly and continuously at low costs.
As a service, it has relatively clean documented APIs and rich sample codes (see the test packages) for a .NET or front end ASP.Net web developer who has limited knowledge about relational databases to work with. Because of this, it can be used in various applications, including but not limited to Asp.Net membership management.
No real databases are needed for small data sets (say, less than 50,000 rows) since it can be initially attached to in-memory databases of ours and it is much faster and cheaper than using a traditional database engine when the data sets are small. When your system grow to a size that in-memory databases are not suitable, we could provide adaptors and data migrators to attach it to a selected database engine aquired by and licensed to you. However, do not use the demo service for production system since it uses .NET serialization methods designed for remoting, not for long time persistence. Microsfot could upgrade it in the future as the .NET framework grows that may render old data files not readable (it happend serveral times in our experiences). Send me a private message at (sqying AT archymeta.com, do not send to my registered e-mail here since the system is down for a while) if you like to know more about it.
Having way too many emails to deal with? Try our SQLized solution: Email Aggregation Manager[ ^] which gets your email sorted, found and organized beyond known precision.
|
|
|
|
|
I agree with both RedDK and Ravi but will strongly recommend SQL Server (express or compact) but it may be overkill for what you require. Access bleh may actually be more appropriate.
However some of the other suggestions on small specialised tools (filemaker etc) may be even more appropriate, you should look at them in light of your requirements and skill level. If you are going to develop an app against a database definitely use SQL Server it insure the app has plenty of growth potential.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
C-P-User-3 wrote: I just want to set up a system that I can use to track a set of people
So create a custom system - basically write your own simple database.
You either used fixed record sizes or create an index to find records. Probably easiest if the index is in another file.
If you go this route then make sure you use an API in your code that completely separates the rest of the code from the storage mechanism. That way you can replace it later on if you want.
|
|
|
|
|
Hi,
Could you assist me in which language do I need to write code for the Chat room communicator.It should be like a group chat and If the communicator ask one question via chat room to the group the known person can answer via communicator, So that everyone understands what is the question asked and what is the answer provided. So I need help to create the broadcasting chat room. Kindly assist me by providing the code for this project.
Gnanasekar
|
|
|
|
|
|
Hi all,
I have a project that I'm going to do.There's a table that has to be normalized.I've tried the normalization roughly.But i need your solution just to check mine with yours.Here's the table with sample data.
I hhave taken Pay Item as a primary key:
Pay Item Description Bridge Type Span Unit Quantity
81.02(a)-I Soft materials-0-2m Slab 6 m3 726.092
81.02(a)-I Soft materials-0.2m Slab 8 m3 182.442
81.02(a)-I Soft materials-0.2m Slab 10 m3 255.36
81.02(a)-I Soft materials-0.2m T-Girder 12 m3 726.092
81.02(a)-I Soft materials-0.2m T-Girder 14 m3 329.864
81.02(a)-ii Soft materials Slab 6 m3 123.456
81.02(a)-ii Soft materials Slab 8 m3 240.762
81.02(a)-ii Soft materials T-Girder 12 m3 556.762
81.02(a)-ii Soft materials T-Girder 14 m3 192.56
|
|
|
|
|
ah ... no - why dont you post what your table defs etc are - give it your best shot - else for all we know we could be doing your homework - and we dont do homework
|
|
|
|
|
Let me show you my trial:
First I put (PayItem,Description and unit)on a single table,
Second (BridgeType,Span,quantity)on another table payitem as a foreign key.
Now bridge type and span are making the redundancy problem,what should i do now?
|
|
|
|
|
Nebilo wrote: I've tried the normalization roughly
How?
Doesn't look like it's in 1NF; the primary key isn't an atomic fact, and there are repeating groups.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
This is the original table,not the normalized one.
|
|
|
|
|
Ah, the old "I've solved it, but I'm not going to show you; I want to see your solution first so I can check" line.
Which translates as, "I haven't solved it; I want you to solve it for me".
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Let me show you my trial:
First I put (PayItem,Description and unit)on a single table,
Second (BridgeType,Span,quantity)on another table payitem as a foreign key.
Now bridge type and span are making the redundancy problem,what should i do now?
|
|
|
|
|
Nebilo wrote: First I put (PayItem,Description and unit)on a single table,
Why?
Normalization consists of a set of rules that one can apply, one after the other. As is, the table is in 0NF. A "normalized" model is usually in BCNF (3NF+). That means that one verifies the rules for each level.
If you follow the rules (!) we'd get exactly the same model.
Nebilo wrote: what should i do now?
Start at the wikipedia, and see how you can turn your pile of data into 1NF.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
