moving data from staging db to orignal db

Question

Hello friends

Actually i was working on oracle to sql migration

I had moved all the data from oracle to SQL using SSIS in some staging DB in a instance. This staging db is not the one in which i want the data this is just to have data in sql once. The orignal DB in which i want this data is in the same instance and let us suppose it DBMIC. I want to move data in this DBMIC from that staging DB. Both staging DB and DBMIC are in same instance. But the design of DBMIC is very normalized. My question is:

Q:1) How should i move the data from Staging DB to DBMIC as both are in same DB and the DBMIC is very normalized?

Thanks in advance

---

dimrd_SQL

Answer 1

Hi rd_278,

 

How should i move the data from Staging DB to DBMIC as both are in same DB and the DBMIC is very normalized

If you want to make data normalized, I would like to recommend that you write customized code to complete this work.

If you want to use SQL Server Integration Services to complete this normalized work, please ask it in SQL Server Integration Services forum and you will get specific support.

 

If anything is unclear, please let me know.

---

Regards,
Tom Li

Answer 2

Thanks tom

According to your words there are two ways one by writing queries and the other by Using SSIS right.

But my question is that is it possible to use ssis in the same instance?

Secondly which one is better way?

Thanks

---

dimrd_SQL

Answer 3

Hi rd_2718,

But my question is that is it possible to use ssis in the same instance?

Yes.

 

Secondly which one is better way?

It is hard to say which one is better.

If the database structure is very simple, for example we just have a few tables, it will be better if we write queries. If ther is many objects in original database, write queries will be a hard work.

If we want to do the same work many times, it will be better if we use SQL Server Integration Services (SSIS) for we could reuse this SSIS package.

Meanwhile the control of data flow and the handling of error will be very easy if we use SSIS.

 

If anything is unclear, please let me know.

---

Regards,
Tom Li

Answer 4

i think in my case SSIS will be better as in staging there are only 150 tables but the original one has 400 and the names are different even columns are different.

So am i Right?

Second question is it seems very complex with SSIS even so do i need the help from legacy application developers and also from the new application guys from MS SQL side as i think DBA cant know which column the data should go and only developer can tell. AM I THINKING RIGHT WAY?

Thanks

---

dimrd_SQL

Answer 5

As you said now i am moving rest of the issue to SSIS forum as ACC to you that is the rt Place

Thanks for advice

---

dimrd_SQL