all groups > sql server replication > february 2004 >
You're in the

sql server replication

group:

SQL-DMO and VB.Net



SQL-DMO and VB.Net John NO[at]SPAM hokykoky.com
2/14/2004 6:12:29 PM
sql server replication: I am using Sql Server 2000 and MSDE. I want to use merge replication.
The primary database is on the SQL Server. When I install the client
app written in VB.Net, should the client create a local identical DB
to the one on the server or is there a way to pull down a copy of the
database from the server to the client. I am not sure how the
architecture works, any help appreciated.

Regards
John


----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
SQL-DMO and VB.Net Paul Ibison
2/15/2004 4:35:13 AM
John,
when the merge process first starts, a snapshot of the
articles is created. This is simply a set of text files.
These files are inserted into the MSDE database using a
command-line utility called BCP. The only requirement is
for there to be a database on MSDE that you can use as one
isn't created on the fly. All this is performed using
snapshot and merge agents. You might want to have a look
at this article on 'How Merge Replication Works' on MSDN
which goes into more detail:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/replsql/repltypes_30z7.asp
Regards,
Paul Ibison




[quoted text, click to view]
Re: SQL-DMO and VB.Net Hilary Cotter
2/15/2004 9:44:43 AM
bcp is not used, its odbcbcp.dll, you could use bpc manually to insert data
into your

[quoted text, click to view]

Re: SQL-DMO and VB.Net Paul Ibison
2/15/2004 12:23:26 PM
Hilary,
interesting. Judging by the output files I always assumed
it was bcp. Is there any major distinction or is
odbcbcp.dll simply a set of wraper functions (API) for bcp?
Regards,
Re: SQL-DMO and VB.Net john NO[at]SPAM hokykoky.com
2/15/2004 8:48:56 PM
Thanks Paul, thats a great help. It was probably a silly question, but
Re: SQL-DMO and VB.Net Paul Ibison
2/16/2004 10:03:09 AM
Thanks,
Re: SQL-DMO and VB.Net Hilary Cotter
2/16/2004 10:09:30 AM
odbcbpc.dll seems to have all the bcp functions inside it. For instance
rename your bcp.exe file on your publisher/distributor/subscriber to
something else, and then try to run and distribute your snapshot.

You will find the snapshot is built and deployed successfully.

I don't exactly know what you mean by major distinction. I know very little
about odbcbcp.dll except its role in snapshot generation and application. It
seems quite undocumented.

[quoted text, click to view]

AddThis Social Bookmark Button