Arthur wrote:
> How to duplicate a database from one PC to another (remote computer)
> over the internet ?
>

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:5agc35F2nbc49U1@mid.individual.net...
> hi Arthur,
> Arthur wrote:
>> How to duplicate a database from one PC to another (remote computer)
>> over the internet ?
>>
>
> you usually generate the DDL + DML scripts to be run on the remote server
> to re-generate the database on it, or you can backup your local database,
> copy it to the remote server, and there restore it locally on it..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> --------- remove DMO to reply
>

> thanks, I will try backup/restore... to see how it works
>
> Do I need to keep database in the same directory on duplicated server,
> or it could be just anywhere ?
> Arthur

> "Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
> news:5agc35F2nbc49U1@mid.individual.net...
>> hi Arthur,
>> Arthur wrote:
>>> How to duplicate a database from one PC to another (remote computer)
>>> over the internet ?
>>>
>>
>> you usually generate the DDL + DML scripts to be run on the remote
>> server to re-generate the database on it, or you can backup your
>> local database, copy it to the remote server, and there restore it
>> locally on it.. --
>> Andrea Montanari (Microsoft MVP - SQL Server)
>> http://www.asql.biz http://italy.mvps.org
>> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
>> --------- remove DMO to reply
>>
>
>
>