Transfer the data

Question

Post reply

Transfer the data

vs.satheesh

SSCrazy

Points: 2392
More actions
January 16, 2014 at 6:26 am

#288424

Dear All
In my project i have two different environment of server. One for staging ,another one for production server. I have 50 tables in my project.How to move the changed data in one server to another server periodical basis.
I am very beginner in SSIS .Please explain elaborately.Thank you.

Viewing 6 posts - 1 through 5 (of 5 total)

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

That question is way too broad to be answered in just a few lines.

I suggest you search for some tutorials on SSIS or grab a good book.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Lempster SSCoach Points: 15651 More actions · Answer 2

Do you want to move data from Staging to Production or vice-versa? How are you identifying changed data...or is that what your question is? We need a bit more information I think.

Regards

Lempster

Lempster SSCoach Points: 15651 More actions · Answer 3

Koen Verbeeck (1/16/2014)
That question is way too broad to be answered in just a few lines.
I suggest you search for some tutorials on SSIS or grab a good book.

+1 🙂

vs.satheesh SSCrazy Points: 2392 More actions · Answer 4

Hi My question is i want move data from production server to testing server.I want take transfer the data in source to destination in all the 50 tables.But one condition only one package will do this process.Modified and inserted records only transfer the records

Lempster SSCoach Points: 15651 More actions · Answer 5

vs.satheesh (1/16/2014)
Hi My question is i want move data from production server to testing server.I want take transfer the data in source to destination in all the 50 tables.But one condition only one package will do this process.Modified and inserted records only transfer the records

Presumably you don't care about overwriting data on a Test server so why wouldn't you just backup the Production database and restore it to the Test instance? You could use SSIS to acheieve the same outcome, but it would be more effort.

If on the other hand you want to copy only new and updated data from one database to another then, yes, SSIS is the appropriate tool. Have a look at the following links:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62063/

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/69766/