November 27, 2011 at 11:41 pm
hi,
i am looking for a free replication tool that may work with express versions of sql-server
the ideal is that it can be executed from a command line
thanks and good day
November 29, 2011 at 9:55 am
Not possible as far as I'm aware, you could custom code a log shipping setup to have a read only copy available else where, but this would not be real time replication of data. The idea would be:
1. Set Database Recovery Mode to full on source db
2. Take Full backup
3. Setup T-Log backups to run every X Minutes, no sql agent in express from what I remember so would need to be windows job calling sqlcmd.
4. Restore the full db back on the destination server with standby
5. Setup a windows job calling a batch file to copy the T-log backups across to the destination server
5. Setup a windows job to restore the T-logs backups in order to the destination database with standby
Other options are to routinely truncate the destination tables then BCP the data from the source to file, then from file to the destination. Again not real time. Or just by a standard edition licence for SQL.
MCITP SQL 2005, MCSA SQL 2012
November 29, 2011 at 11:12 am
You could use BCP to bulk output all the tables in the source database, then truncate and BCP import into the target database. No need to buy a third party tool, just command-line BCP operations.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 29, 2011 at 2:49 pm
What problem are you trying to solve with this replication?
An alternative to the ideas mentioned, you might be able to cobble something up with triggers and linked servers, but it would have some serious drawbacks.
November 30, 2011 at 5:44 am
i will tell you the whole story :
i have a desktop application that use firebird
i am migrating some parts of this application to the web using sql-server database since i didn't found a good and cheap web hosting that support firebird
i have already translated almost all the database including the stored procedures to sql-server locally
now,
since the firebird database change every day, what i want to do
make a little desktop application that read the firebird tables, empty all the local sql-server tables, and insert the data from firebird to the local sql-server
after that make a replication between the local sql-server database and that one hosted on the web hosting
that's all
what do you think about my genius :-D?
November 30, 2011 at 6:44 am
Are you doing this just for yourself, or as some sort of commercial application? If commercial, you might want to look into a higher version of SQL Server, to make sure you're not violating the license. If just for yourself, you might want to use Dev Edition (it's about $50 usually), which has all the features of Enterprise Edition, including real replication and all that. You can use Dev Edition if you're just playing around with development and proof of concept work, but not for any sort of commercial use.
Otherwise, if you want to stick with Express, I'd look into RedGate SQL Data Compare for your sync tool.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 30, 2011 at 12:41 pm
GSquared (11/30/2011)
Otherwise, if you want to stick with Express, I'd look into RedGate SQL Data Compare for your sync tool.
To remain neutral ...
Other data comparison tools are available.
December 1, 2011 at 7:15 am
MysteryJimbo (11/30/2011)
GSquared (11/30/2011)
Otherwise, if you want to stick with Express, I'd look into RedGate SQL Data Compare for your sync tool.To remain neutral ...
Other data comparison tools are available.
Yep, and you can build your own too, of course.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply