How to use UNC path to syncronize data

Can you do a backup of that database on your WHP's server,
and then download the .bak file to your pc? If yes, then
you can restore the .bak file as a new database on your PC
or overwrite existing database.
I don't know anything about the ASP.Net Enterprise Manager
so I have to ask you this dumb question: What kind of
access do you have to the remote sql server from your
local pc?
hth.

>--Original Message--
>Hello:
>I'm working with the SQL server database that is located
on my web hosting
>provider's server. I can control it by ASP.Net Enterprise
Manager, which is
>very limited comparing to the regular Enterprise Manager.
I need to
>syncronize data on this server with the data in another
SQL server on my PC.
>I've never done this before. I know that I have to do it
programmatically
>using T-SQL statements that use UNC path to import and
export data. Where
>can I learn more about it? Could you recommend me some
articles about it or
>give me some code examples?
>I would appreciate your suggestions.
>Thank you,
>--
>Peter Afonin
>
>.
>Thank you.
My WHP can do daily backups of my database, but I cannot download them.
I don't actually have any access directly from my PC to the remote SQL
server. I use this ASP Enterprise Manager which is actually an ASP.Net
application (www.aspenterprisemanager.com) that I installed in my web space
and that imitates SQL server Enterprise manager, but is much more limited.
Peter
<anonymous@.discussions.microsoft.com> wrote in message
news:deb501c3f0b4$474bb7f0$a101280a@.phx.gbl...
> Can you do a backup of that database on your WHP's server,
> and then download the .bak file to your pc? If yes, then
> you can restore the .bak file as a new database on your PC
> or overwrite existing database.
> I don't know anything about the ASP.Net Enterprise Manager
> so I have to ask you this dumb question: What kind of
> access do you have to the remote sql server from your
> local pc?
> hth.
>
> on my web hosting
> Manager, which is
> I need to
> SQL server on my PC.
> programmatically
> export data. Where
> articles about it or