updating database in different location

[william humphrey]

I already do time stamp all the records and thank you for the suggestion
for having a slave and master database.

Can you tell me about hosting vServer on commercial server? Can this be
done on a goDaddy hosted website (like you would with MySQL)? Or can we do
something innovative like mine sweeper (a game) does on dropbox?

I think most of my merge database problems would be solved with the
database hosted on the internet like MySQL.

On Fri, Jun 1, 2012 at 1:41 PM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> On 6/1/12 8:34 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:
>
> Hi William,
>
> > I see that there is exactly the utility I need for merging two databases
> for
> > SQLite. It is called SQLiteSyn. It's too bad there's not something like
> that
> > for Valentina databases. SQLabs slr
>
> I guess it will work only for dbs in 100 records normally
>
>
> > On Fri, Jun 1, 2012 at 1:07 PM, william humphrey <
> bill at bluewatermaritime.com>
> > wrote:
> > OK - I realize that's too hard. But can someone give me some simple
> > instruction on hosting vServer on a commercial server, like one of my
> goDaddy
> > websites or on drop-box like the way mine craft is hosted there. I have
> only
> > used vServer on my local network. Since my connection to the internet is
> too
> > too flaky I can't use one of my computers to host vServer.
> >
> > Can anyone help me?
>
>
>
> > On Thu, May 31, 2012 at 9:31 PM, william humphrey <
> bill at bluewatermaritime.com>
> > wrote:
> > Is there a way to merge to different databases with SQL? One database
> has new
> > data and the other has different new data and I'd like to merge that
> data.
>
> This task has general name replication.
>
>
> > Maybe it would be less of a problem if I have one database which we
> export
> > with SQL everything new after a certain date and then import that into
> the
> > other database (ignoring any changes in that database) and just adding
> the new
> > data on at the end. Is this something that can be done without risking
> > corrupting of data and all the indexes and links?
> >
> > The problem is the lack of internet connection in the other location.
>
> Describe your task at first please
>
> You need do this once?
> Or regullary, when some device becomes online ?
>
>
> Usually solution is based on
>
> * on db is named master
>
> * second db is named slave
>
> * each table has additional TimeStamp field
>  each change of record should modify this
>  then it is easy enough recognise records that was changed
>
>
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120601/3c30d5ac/attachment.html>