[BNM] MS SQL - DTS or SSIS

[Wayne Douglas]

SSIS is the new name for DTS - kinda.

Using DTS/SSIS you can create a set of tasks to connect to a DB server and
pump over whatever you want - it's all fairly graphical and wizard based you
can also perform tasks on the data along the way (clean it, restructure it
etc). Depending on what you want to do it may be better to create an app
that does it for you.

If you have a .bak then you can just restore it to your local ms sql and go
from there - I guess it depends on what the destination server looks like -
got any more info?

w://

2009/1/6 Jay Caines-Gooby <jay at gooby.org>

> I've generated a backup of an MS SQL database on a remote server.
> Apparently I can get a local copy of this using DTS or SSIS. Can
> anyone clue me in?
>
> --
> Jay Caines-Gooby
> jay at gooby.org
> +44 (0)7956 182625
> skype: jaygooby
> gtalk: jaygooby at gmail.com
> AIM: jaygooby
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>