[dba-SQLServer] Export / Import SQL Dbs

And, you can still use SSIS to do processing.

At 04:39 PM 9/27/2013, you wrote:
>Date: Fri, 27 Sep 2013 17:39:29 -0400
>From: Arthur Fuller <fuller.artful at gmail.com>
>To: Discussion concerning MS SQL Server
>         <dba-sqlserver at databaseadvisors.com>
>Subject: Re: [dba-SQLServer] Export / Import SQL Dbs
>Message-ID:
>         <CAEPJO1hiFyLkQ3Nnxz3g7FwTB5RsjVNKnZULRwC4PH22YCW3zg at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>Thanks to you, Gustav. I have all the requisite parts installed. Now all I
>have to do is connect to both these beaches and launch my surfboard .
>That's what unpaid weekends are for.
>
>A.
>
>
>On Fri, Sep 27, 2013 at 5:26 PM, Gustav Brock <Gustav at cactus.dk> wrote:
>
> > Hi Arthur
> >
> > If you have admin rights, this should be trivial - as handling any other
> > remote SQL Server.
> >
> > If it is Azure SQL, it's a bit different, but SSMS is still the tool:
> >
> >
> > 
> http://www.windowsazure.com/en-us/develop/net/common-tasks/sql-azure-management/
> >
> > /gustav
> >
> > >>> fuller.artful at gmail.com 27-09-13 21:49 >>>
> > 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

Robert L. Stewart

Any fool can write code that a computer can understand. Good 
programmers write code that humans can understand. --Martin Fowler

www.WeBeDb.com
www.DBGUIDesign.com
www.RLStewartPhotography.com