[dba-SQLServer] Export / Import SQL Dbs

Gotcha. Hence our justification for charging the big bucks per hour LOL.
Thank you, MS!!

Or as a fellow programmer once said, "It was hard to write, therefore it's
hard to use."

A.


On Fri, Sep 27, 2013 at 5:05 PM, David McAfee <davidmcafee at gmail.com> wrote:

> When we need to get data from SQL Azure and NoSQL, we'll write services and
> interact with them via C#.
>
> A much more complicated method for doing (what should be) simple work.
>
> D
>
>
> On Fri, Sep 27, 2013 at 12:49 PM, Arthur Fuller <fuller.artful at gmail.com
> >wrote:
>
> > I'm currently at work on a project involving two SQL Server dbs that live
> > in a cloud. I have been granted access as admin to both. I want to
> extract
> > all the data from DataSource 1 and then perhaps do some mods due to
> > field-name conflicts or at least non-parallel names, and subsequently
> > import said extract into the new db.
> >
> > This is new turf for me. Most of the time invested shall be unbillable,
> > since this is primarily an educational experience, although at least a
> few
> > hours shall be deemed billable.
> >
> > If I had local copies of both Source and Target, then I could easily whip
> > up an SSIS ETL transform that would do the job, but I am unsure how to
> > handle the remote targets.
> >
> > Anyone done this sort of task before? Any tips and hints to help me
> through
> > this?
> >
> > --
> > Arthur
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Arthur