Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Is it possible to replicate db with SQL Express Only?

  
   Database Forums (Home) -> MSDE RSS
Next:  pccw solutions, cyber port 6/F, lawrence chan , b..  
Author Message
Gigi

External


Since: Jul 11, 2007
Posts: 1



(Msg. 1) Posted: Tue Jul 10, 2007 10:56 pm
Post subject: Is it possible to replicate db with SQL Express Only?
Archived from groups: microsoft>public>sqlserver>msde (more info?)
To all SQL guru

I understand MS SQL Express can only "subscribe" which means u need Full
version of MS SQL to do the "publication" .

Is there any other way to do some sort of replication without the full MS
SQL?


Cheers
Gigi

 >> Stay informed about: Is it possible to replicate db with SQL Express Only? 
Back to top
Login to vote
"William

External


Since: Mar 21, 2007
Posts: 40



(Msg. 2) Posted: Wed Jul 11, 2007 9:00 am
Post subject: Re: Is it possible to replicate db with SQL Express Only? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Yes. ADO.NET 3.0 Synchronization Services (in Beta now) due to ship early
next year.

--
____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------

"Gigi" wrote in message

> To all SQL guru
>
> I understand MS SQL Express can only "subscribe" which means u need Full
> version of MS SQL to do the "publication" .
>
> Is there any other way to do some sort of replication without the full MS
> SQL?
>
>
> Cheers
> Gigi

 >> Stay informed about: Is it possible to replicate db with SQL Express Only? 
Back to top
Login to vote
Andrea Montanari

External


Since: Sep 13, 2003
Posts: 851



(Msg. 3) Posted: Wed Jul 11, 2007 12:34 pm
Post subject: Re: Is it possible to replicate db with SQL Express Only? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
hi Gigi,
Gigi wrote:
> To all SQL guru
>
> I understand MS SQL Express can only "subscribe" which means u need
> Full version of MS SQL to do the "publication" .
>
> Is there any other way to do some sort of replication without the
> full MS SQL?

AFAIK, actually not... you could "write your own" code to perform a "poor's
man log shipping" solution, like
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1742 or the
like...but still it's a "poor's man" solution..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply
 >> Stay informed about: Is it possible to replicate db with SQL Express Only? 
Back to top
Login to vote
Mike Shilov

External


Since: Feb 24, 2011
Posts: 1



(Msg. 4) Posted: Thu Feb 24, 2011 1:25 pm
Post subject: Re: Is it possible to replicate db with SQL Express Only? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
What you want can be called "poor man's replication" and "SQLBackupAndFTP" + "One-Click SQL Restore" are exactly the programs to do it. For less than three databases you can automate this process absolutely free. Look here: http://sqlbackupandftp.com/forum/yaf_postsm907_Is-this-tool-for-me.aspx#post907

> On Tuesday, July 10, 2007 10:20 PM Gigi wrote:

> To all SQL guru
>
> I understand MS SQL Express can only "subscribe" which means u need Full
> version of MS SQL to do the "publication" .
>
> Is there any other way to do some sort of replication without the full MS
> SQL?
>
>
> Cheers
> Gigi


>> On Wednesday, July 11, 2007 6:34 AM Andrea Montanari wrote:

>> hi Gigi,
>> Gigi wrote:
>>
>> AFAIK, actually not... you could "write your own" code to perform a "poor's
>> man log shipping" solution, like
>> http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1742 or the
>> like...but still it's a "poor's man" solution..
>> --
>> Andrea Montanari (Microsoft MVP - SQL Server)
>> http://www.asql.biz http://italy.mvps.org
>> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
>> --------- remove DMO to reply


>>> On Wednesday, July 11, 2007 12:00 PM William \(Bill\) Vaughn wrote:

>>> Yes. ADO.NET 3.0 Synchronization Services (in Beta now) due to ship early
>>> next year.
>>>
>>> --
>>> ____________________________________
>>> 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)
>>> -----------------------------------------------------------------------------------------------------------------------
>>>
>>> "Gigi" wrote in message
>>>


>>> Submitted via EggHeadCafe
>>> Excel JSON Storing Data
>>> http://www.eggheadcafe.com/tutorials/aspnet/233e58b3-72f4-4220-8d45-37...44e795e
 >> Stay informed about: Is it possible to replicate db with SQL Express Only? 
Back to top
Login to vote
Display posts from previous:   
   Database Forums (Home) -> MSDE All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]