how to merge two different databases (eg: Oracle and SQL Server)

  • 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 🙂

  • 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).

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • 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]

  • 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 🙂

  • is the merged database in sql or oracle?

    "Keep Trying"

  • 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

  • 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

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • thankz lot

  • 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

  • bro if u get idea then please share with me.... thanx in advance

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply