September 14, 2009 at 12:53 am
wt i need to do is to merge 2 different databases like oracle and sql server.. how can v do this.. any related article would be highly appreciated..
thanks in advance 🙂
September 14, 2009 at 1:11 am
What you can do here is, design a SSIS package where you have the freedom to define the source and destination databases as well as several types of transformations (on the basis of which data you want and how you want).
September 14, 2009 at 1:51 am
shanikasuwaris (9/14/2009)
wt i need to do is to merge 2 different databases like oracle and sql server.. how can v do this.. any related article would be highly appreciated..thanks in advance 🙂
Hard to find an article, when it is not specific. Like already mentioned you can create a SSIS (SQL Server Integration Services) package, which you can use to pull data from both SQL Server and Oracle together, or you could use a Linked Server in SQL Server to connect to your Oracle Database.
Normally with a merge, you would have what is called a staging Database in the database that you are going to use as your main database. and you could use SSIS to populate this staging database with the data from both SQL Server and Oracle.
If you can provide more detail on what you want to achieve, we can go into more detail.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 14, 2009 at 2:08 am
i too am new to this that is why i couldnt provide further information sorry about that.. Thank u so much for ur replies i will do my search along the information u both provided.. Thanks again 🙂
September 14, 2009 at 4:31 am
is the merged database in sql or oracle?
"Keep Trying"
September 14, 2009 at 11:59 pm
Actually I'm looking for some info for an Uni assignment. Bellow is the scenario,
Scenario:
Two universities, formally competing for a similar student market, have decided to combine forces and create a large super-university. In order to manage the transition into a single entity, the new organisation has decided to purchase a new enterprise level central course and student record management database system. All course and student details from both organisations will be merged into this new system which will be designed to integrate both sets of data. This database is to be fully web-enabled and is to be accessed by both staff and students at the new university. It is expected that the new system will be running on a completely new operating system and database environment from the previous two systems, and will be accessed using 3rd party scripting tools and web server environments. As a security consultant you have been asked to prepare the above report as a blueprint to these organisations as to how this transition can be managed from the security, data integrity and vulnerability point of view. When beginning your research on this assignment you should look at issues of technology change management and porting of system data from one environment to another.
I have to cover following in my report and i'm free to do any assumptions. I don't have much knowledge in databases because I'm a network security student..
•The areas of vulnerability or inherent risk
•Description of the impact of lack of security
•Recommended sections to be included in the organisation’s security policy to address these vulnerabilities
•Recommended security measures to minimize the risks identified
•Issues in software compatibility, platform, maintainability
•Database backup methodologies
•Change management
•Procedures to ensure compliance to the security policy and procedures supporting the recommended protective measures.
Thanks again
September 15, 2009 at 12:19 am
moreover seems to be a college Project. However, just to give you an overview, here is what you can do.
1) Since you already have the sources like Univ A and Univ B
Recognize what data needs to be merged and in which table they resides and what are those actual columns yo u need to merge.
3) create one new database lets call it ConsUniv. The schema and design of this database completely depends on Step 2. you may need to add some more tables And/or columns depending upon how you want to tell the end user which Univ that they belong (incase if you want to)
4) Design one SSIS package and add the connection managers accordingly.
5) Add one data flow object>double click it and define the source as Univ A and destination as ConsUniv.
Here in both of the place you can write the SQL Query to program what data you are suppose to merge.
6) Repeat step 5 it for Univ B database.
once you are done with the data transformation, you can move to the security part of the database "ConsUniv" which is now your main database.
I believe, if your web application is going to provide the data to the end users, you may need to add only application account to your database with minimum read,write and execute permission (generally application account has DBO permission).
Rest is I suggest that you first read the SSIS functionality in SQL Server Books OnLine (BOL) to get an overview of how it works.
HTH
September 15, 2009 at 8:39 pm
thankz lot
September 15, 2009 at 9:33 pm
thanks a lot for the long reply..yeah now i have an idea what do.When i'm planning the document I got another problem, when we think of security issues, do we have to create a policy to do the migration(database and operating system)
once again thanks...ur long reply helped a lot
October 7, 2015 at 12:54 am
bro if u get idea then please share with me.... thanx in advance
October 7, 2015 at 1:07 am
raj_saroj_yadav (10/7/2015)
bro if u get idea then please share with me.... thanx in advance
You just responded to a post which is six years old. I reckon all these 'bros' got their ideas a long time ago.
If you have something new to ask, please create a new thread.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply