How to use UNC path to syncronize data

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 AfoninCan 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.
> >--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
> >
> >
> >.
> >