Creating Replication

Hello there
I've started creating my own replication between two databases with the same
structure:
Local server and internet server.
The Internet server is not updated.
When i configure the local server for replication it gave me an error that i
can't use the local server agent.
After that i tried to create publisher. Then it didn't let me to build
transactional publication as a result if licence
what can cause the problem?
any help would be useful
what is the exact error message you are getting?
"Oded Kovach" <roygoldh@.hotmail.com> wrote in message
news:%23DM8hcWpEHA.2636@.TK2MSFTNGP09.phx.gbl...
> Hello there
> I've started creating my own replication between two databases with the
> same
> structure:
> Local server and internet server.
> The Internet server is not updated.
> When i configure the local server for replication it gave me an error that
> i
> can't use the local server agent.
> After that i tried to create publisher. Then it didn't let me to build
> transactional publication as a result if licence
> what can cause the problem?
> any help would be useful
>
|||Whell Hilery
The problem is that i ran it from MDSE (as i think)
when i ran it afterword from Enterprize the error didn't came back
But then i stuck with diffrent issue:
After i create the publisher as transactional replication I pressed Push
Subscriber
I filled all the data that was nessesery on the wizart and it didn't gave me
in any level which table i would like to subscribe to or which database
I realy don't understand what's going on
can you help me on it?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uq9PYmWpEHA.1272@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> what is the exact error message you are getting?
> "Oded Kovach" <roygoldh@.hotmail.com> wrote in message
> news:%23DM8hcWpEHA.2636@.TK2MSFTNGP09.phx.gbl...
that
>
|||I'm still unclear as to what your error/problem is. Could you enable logging
and paste the logs here?
Please follow the steps outlined here to enable logging.
http://support.microsoft.com/default...&Product=sql2k
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Oded Kovach" <roygoldh@.hotmail.com> wrote in message
news:Og61w7WpEHA.3464@.TK2MSFTNGP14.phx.gbl...
> Whell Hilery
> The problem is that i ran it from MDSE (as i think)
> when i ran it afterword from Enterprize the error didn't came back
> But then i stuck with diffrent issue:
> After i create the publisher as transactional replication I pressed Push
> Subscriber
> I filled all the data that was nessesery on the wizart and it didn't gave
me[vbcol=seagreen]
> in any level which table i would like to subscribe to or which database
> I realy don't understand what's going on
> can you help me on it?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uq9PYmWpEHA.1272@.TK2MSFTNGP09.phx.gbl...
the
> that
>

Creating link via Internet

Hello there
I have local sql server database on my server
I have also another sql database on my internet
I would like to transfare data from my local server to the internet server
at 12:00 pm every day
How can i create kink to the database on the server?
A few ways:
1. SQL Replication.
2. SQL DTS job
3. SQL Agent Scheduled Job
See SQL Books on Line. All three of these options are covered in depth.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.