|
|
You're in the
sql server msde
group:2005 Express Sync
sql server msde:
Hi,
Is there any way to keep 2 SQL 2005 Express instances in Synch. I know that SQL 2005 Express doesn't support Replication between them. What other options do I have without upgrading to SQL 2005 Server. Any 3rd party application or options with in 2005. One of the SQL 2005 Express will be the "Master" and I will like to sych or send the new that two the seconds instance. There is not update or deletes to this database it will only have new inserts. Thanks Julio D
I expect that the new ADO.NET Synchronization Services API might be of some
use. It can be used between SQL Express instances (as well as other data sources) to keep database tables in sync. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) Between now and Nov. 6th 2006 you can sign up for a substantial discount. Look for the "Early Bird" discount checkbox on the registration form... ----------------------------------------------------------------------------------------------------------------------- Microsoft MVP, Author, Mentor Microsoft MVP [quoted text, click to view] "Julio Delgado" <jdelgado89@hotmail.com> wrote in message news:OeKG$SDgHHA.1216@TK2MSFTNGP03.phx.gbl... > Hi, > > Is there any way to keep 2 SQL 2005 Express instances in Synch. I know > that SQL 2005 Express doesn't support Replication between them. What other > options do I have without upgrading to SQL 2005 Server. Any 3rd party > application or options with in 2005. > > One of the SQL 2005 Express will be the "Master" and I will like to sych > or send the new that two the seconds instance. There is not update or > deletes to this database it will only have new inserts. > > Thanks > > Julio D >
I think it would be a waste of time to reinvent the wheel being created with
Synchronization Services. It's available now in CTP form. Yes, it's likely to change between now and when it ships this fall, but it should solve your problem. -- William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest books: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Julio Delgado" <jdelgado89@hotmail.com> wrote in message news:uoHXfnTgHHA.4916@TK2MSFTNGP06.phx.gbl... > Bill, thanks for the info, do you know of another tool since I need it for > a current application that we have. > > Thanks > > Julio > > "William (Bill) Vaughn" <billva@NoSpamAtAll_betav.com> wrote in message > news:O$RHGRGgHHA.1244@TK2MSFTNGP04.phx.gbl... >>I expect that the new ADO.NET Synchronization Services API might be of >>some use. It can be used between SQL Express instances (as well as other >>data sources) to keep database tables in sync. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> Between now and Nov. 6th 2006 you can sign up for a substantial discount. >> Look for the "Early Bird" discount checkbox on the registration form... >> ----------------------------------------------------------------------------------------------------------------------- >> >> >> Microsoft MVP, Author, Mentor >> Microsoft MVP >> "Julio Delgado" <jdelgado89@hotmail.com> wrote in message >> news:OeKG$SDgHHA.1216@TK2MSFTNGP03.phx.gbl... >>> Hi, >>> >>> Is there any way to keep 2 SQL 2005 Express instances in Synch. I know >>> that SQL 2005 Express doesn't support Replication between them. What >>> other options do I have without upgrading to SQL 2005 Server. Any 3rd >>> party application or options with in 2005. >>> >>> One of the SQL 2005 Express will be the "Master" and I will like to sych >>> or send the new that two the seconds instance. There is not update or >>> deletes to this database it will only have new inserts. >>> >>> Thanks >>> >>> Julio D >>> >> >> > >
Bill, thanks for the info, do you know of another tool since I need it for a
current application that we have. Thanks Julio [quoted text, click to view] "William (Bill) Vaughn" <billva@NoSpamAtAll_betav.com> wrote in message news:O$RHGRGgHHA.1244@TK2MSFTNGP04.phx.gbl... >I expect that the new ADO.NET Synchronization Services API might be of some >use. It can be used between SQL Express instances (as well as other data >sources) to keep database tables in sync. > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no > rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > Between now and Nov. 6th 2006 you can sign up for a substantial discount. > Look for the "Early Bird" discount checkbox on the registration form... > ----------------------------------------------------------------------------------------------------------------------- > > > Microsoft MVP, Author, Mentor > Microsoft MVP > "Julio Delgado" <jdelgado89@hotmail.com> wrote in message > news:OeKG$SDgHHA.1216@TK2MSFTNGP03.phx.gbl... >> Hi, >> >> Is there any way to keep 2 SQL 2005 Express instances in Synch. I know >> that SQL 2005 Express doesn't support Replication between them. What >> other options do I have without upgrading to SQL 2005 Server. Any 3rd >> party application or options with in 2005. >> >> One of the SQL 2005 Express will be the "Master" and I will like to sych >> or send the new that two the seconds instance. There is not update or >> deletes to this database it will only have new inserts. >> >> Thanks >> >> Julio D >> > >
friggin fabulous info, thanks!
I really really hate how they crippled MSDE 3.0 lol [quoted text, click to view] "William (Bill) Vaughn" <billva@NoSpamAtAll_betav.com> wrote in message news:O$RHGRGgHHA.1244@TK2MSFTNGP04.phx.gbl... > I expect that the new ADO.NET Synchronization Services API might be of some > use. It can be used between SQL Express instances (as well as other data > sources) to keep database tables in sync. > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > Visit www.hitchhikerguides.net to get more information on my latest book: > Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) > Between now and Nov. 6th 2006 you can sign up for a substantial discount. > Look for the "Early Bird" discount checkbox on the registration form... > -------------------------------------------------------------------------- --------------------------------------------- > > > Microsoft MVP, Author, Mentor > Microsoft MVP > "Julio Delgado" <jdelgado89@hotmail.com> wrote in message > news:OeKG$SDgHHA.1216@TK2MSFTNGP03.phx.gbl... > > Hi, > > > > Is there any way to keep 2 SQL 2005 Express instances in Synch. I know > > that SQL 2005 Express doesn't support Replication between them. What other > > options do I have without upgrading to SQL 2005 Server. Any 3rd party > > application or options with in 2005. > > > > One of the SQL 2005 Express will be the "Master" and I will like to sych > > or send the new that two the seconds instance. There is not update or > > deletes to this database it will only have new inserts. > > > > Thanks > > > > Julio D > > > >
So use SQL Server Express Edition. Frankly, I've never (as in never) seen a
documented case where the governor was the root cause of a performance problem with MSDE. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- [quoted text, click to view] "Aaron Kempf" <akempf@dol.wa.gov> wrote in message news:uMyRgCCjHHA.3928@TK2MSFTNGP03.phx.gbl... > friggin fabulous info, thanks! > > I really really hate how they crippled MSDE 3.0 > > > lol > > > > "William (Bill) Vaughn" <billva@NoSpamAtAll_betav.com> wrote in message > news:O$RHGRGgHHA.1244@TK2MSFTNGP04.phx.gbl... >> I expect that the new ADO.NET Synchronization Services API might be of > some >> use. It can be used between SQL Express instances (as well as other data >> sources) to keep database tables in sync. >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no > rights. >> __________________________________ >> Visit www.hitchhikerguides.net to get more information on my latest book: >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) >> Between now and Nov. 6th 2006 you can sign up for a substantial discount. >> Look for the "Early Bird" discount checkbox on the registration form... >> -------------------------------------------------------------------------- > --------------------------------------------- >> >> >> Microsoft MVP, Author, Mentor >> Microsoft MVP >> "Julio Delgado" <jdelgado89@hotmail.com> wrote in message >> news:OeKG$SDgHHA.1216@TK2MSFTNGP03.phx.gbl... >> > Hi, >> > >> > Is there any way to keep 2 SQL 2005 Express instances in Synch. I know >> > that SQL 2005 Express doesn't support Replication between them. What > other >> > options do I have without upgrading to SQL 2005 Server. Any 3rd party >> > application or options with in 2005. >> > >> > One of the SQL 2005 Express will be the "Master" and I will like to >> > sych >> > or send the new that two the seconds instance. There is not update or >> > deletes to this database it will only have new inserts. >> > >> > Thanks >> > >> > Julio D >> > >> >> > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |