 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / June 2006using BCP while replication is slow
Hi, I have setup replication but it's not very stable i.e sometimes the connection is bad, in this case will using bcp & bulk insert help to allow me to transfer the data faster ? i have tried to use the following commands : bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout Authors.txt -c -Sservername -Usa -Ppassword but how or where shld i put in the -t for using pipe ( | ) and -r for \n ? appreciate ur advise Replication uses bcp under the cover. If your network link is not reliable enough for transferring the initial data set, perhaps you can copy the generated snapshot data to the subscriber using some other means (e.g. a usb hard disk) and then use the alternate snapshot folder feature to apply the snapshot from a different location? Hope that helps. -Raymond > Hi, > [quoted text clipped - 11 lines] > > appreciate ur advise hi, it's actually quite impossible for me to copy the snapshot data to a usb hdd as the subscriber is in another country.. is there other method ? tks & rdgs >Replication uses bcp under the cover. If your network link is not reliable >enough for transferring the initial data set, perhaps you can copy the [quoted text clipped - 10 lines] >> >> appreciate ur advise If you can't transfer it to physical media which you can ship to the subscriber you have to use a snapshot and a unc or ftp copy.  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > hi, > [quoted text clipped - 21 lines] >>> >>> appreciate ur advise i guess i have no choice but it'll be slow still(the transfer) tks & rdgs >If you can't transfer it to physical media which you can ship to the >subscriber you have to use a snapshot and a unc or ftp copy. [quoted text clipped - 4 lines] >>>> >>>> appreciate ur advise Are you looking for an alternative to the initial snapshot initialization process? You might want to consider backup and restore and do a nosync initialization. In SQL Server 2005 this process has been further simplified using the 'replication support only' option. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com (recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html) yes is it done thru the articles where i go to the snapshot and specify one of the options instead of drop and recreate table ? or how can i set it to do a no sync initialization ? appreciate ur advice tks & rdgs >Are you looking for an alternative to the initial snapshot initialization >process? You might want to consider backup and restore and do a nosync [quoted text clipped - 4 lines] >(recommended sql server 2000 replication book: >http://www.nwsu.com/0974973602p.html) Please have a look at these articles for more info on nosync initializations: http://www.replicationanswers.com/NoSyncInitializations.asp http://www.replicationanswers.com/NoSyncOn2005.asp Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com (recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html) I would urge you to use the sync with backup option in SQL 2005, or if you are using merge replication in SQL 2000 use the copy subscription database method. SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi, > [quoted text clipped - 11 lines] > > appreciate ur advise hi , i am using SQL 2000 and using txn replication . is it able to use the copy subscription database method ? tks & rdgs >I would urge you to use the sync with backup option in SQL 2005, or if you >are using merge replication in SQL 2000 use the copy subscription database [quoted text clipped - 5 lines] >> >> appreciate ur advise No, its for merge only and for subscribers under 2 gigs. SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > hi , > [quoted text clipped - 12 lines] >>> >>> appreciate ur advise tk you for the advice >No, its for merge only and for subscribers under 2 gigs. > [quoted text clipped - 3 lines] >>>> >>>> appreciate ur advise |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.