SQL job agent

Hello Friends,

Can i create a job to transfer data from DW from one server to another server DW?

Thanks 

Ran

August 21st, 2015 1:39am

Hi Ranjan

yes you can. there are many options available, the best would be to use the Dataflow task in SSIS to move data from your source DW to the target DW. 

Free Windows Admin Tool Kit Click here and download it now
August 21st, 2015 1:42am

Hi Michael

Can you suggent me briefly or send me the links where i can go through it.

Thanks 

Ranjan DS

August 21st, 2015 1:55am

Hi Ranjan

There are a lot of good tutorials about getting started with SSIS such as this one

http://www.sqlservercentral.com/stairway/72494/

However

I see you asking a lot of questions about a NAV upgrade and migration. This can be a very complicated process and not something a blog is going to solve for you. I'd suggest you get someone who can guide you through the process (Yes this costs money but this is something that can really go wrong very quickly if not done right)


Free Windows Admin Tool Kit Click here and download it now
August 21st, 2015 2:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics