[dba-SQLServer] Export / Import SQL Dbs

Arthur Fuller fuller.artful at gmail.com
Fri Sep 27 16:39:29 CDT 2013


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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
Arthur


More information about the dba-SQLServer mailing list