Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Update Local DB from Online DB?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sadra
Starting Member

Iran
30 Posts

Posted - 15 April 2008 :  22:54:28  Show Profile  Send sadra a Yahoo! Message
Hi to all,

How do can update local db in my computer from my db on my site, by a asp form???????

by this idea we can bakup db & update local db

[red]how soon is too late[/red]

AnonJr
Moderator

United States
5765 Posts

Posted - 16 April 2008 :  13:28:38  Show Profile  Visit AnonJr's Homepage
Details tend to help with these sorts of things... and clarity. Clarity is good.

Since you're posting it here, is it a safe guess you're not talking about a Snitz database you are trying to back up? What type of database is it? What type of application is this for? What are you wanting to do? (with clarity this time)
Go to Top of Page

sadra
Starting Member

Iran
30 Posts

Posted - 19 April 2008 :  01:10:30  Show Profile  Send sadra a Yahoo! Message
Sorry,

I want update my mdb file in my computer from my site on internet by a form (transfer information on my internet site database to my mdb on my computer "my site installed on my com...")

[red]how soon is too late[/red]
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 April 2008 :  03:40:23  Show Profile  Send ruirib a Yahoo! Message
FTP the database file from the server to your computer if Access, use adequate tools to backup, if MySQL or SQL Server. In every single case, you can schedule the backup.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sadra
Starting Member

Iran
30 Posts

Posted - 19 April 2008 :  22:50:27  Show Profile  Send sadra a Yahoo! Message
No, I want update my mdb without ftp, and when i conect to internet, by click on a form the latest data on my site, transfer to local mdb

OR

Inverse


[red]how soon is too late[/red]

Edited by - sadra on 19 April 2008 22:52:18
Go to Top of Page

phy1729
Average Member

USA
589 Posts

Posted - 19 April 2008 :  22:55:27  Show Profile
table editor?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 April 2008 :  03:01:18  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by sadra

No, I want update my mdb without ftp, and when i conect to internet, by click on a form the latest data on my site, transfer to local mdb

OR

Inverse


If you do it, recording all the table changes, for the 3 types of databases, then it will be a very interesting script. Please do post it here when you're done.

As a way of advice, you should be aware that you will need to change all the tables, just to know what was edited and when, so that you can download all the changes that have occurred since the last backup. It's not just a matter of downloading the latest records, but also of downloading any changes that may have ocurred on the existing ones... I'm sure it will be fun to code.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sadra
Starting Member

Iran
30 Posts

Posted - 20 April 2008 :  22:52:21  Show Profile  Send sadra a Yahoo! Message
quote:

If you do it, recording all the table changes, for the 3 types of databases, then it will be a very interesting script. Please do post it here when you're done.




ok, but it is very difficult for me!

We need a script to identify all tables in DB and save the latest changes on "xml" file or "mdb" or..., in a periodic time, then transfer data to other DB...

who can help for this script?

[red]how soon is too late[/red]

Edited by - sadra on 20 April 2008 23:03:51
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 April 2008 :  02:48:16  Show Profile  Send ruirib a Yahoo! Message
What you are asking is very hard to achieve and you obviously have no idea of that!


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sadra
Starting Member

Iran
30 Posts

Posted - 21 April 2008 :  22:56:34  Show Profile  Send sadra a Yahoo! Message
quote:
Originally posted by ruirib

What you are asking is very hard to achieve and you obviously have no idea of that!



!!!!!!!!!!!!!!!!!!!!!

1- a table upkeep latest update time
2- cheking tables were changes after that time by "post date", "reply date" or "edited date" or ...
3- transfer all changed data to destination db

[red]how soon is too late[/red]

Edited by - sadra on 21 April 2008 23:09:53
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 April 2008 :  23:28:45  Show Profile  Send ruirib a Yahoo! Message
You have no idea, really? What about if someone edited their profile - there is no date to record it... and forum or category editing.... or config changes, which could be one of tens of config values... How would you know what has changed?!

I made my point, I won't discuss this any further.
I really hope you enjoy the coding!

P.S.: Databases have a mechanism to do this - it's called replication. Go read a bit about it, maybe then you will finally understand what it is, how it can be implemented and the effort required to do it, which even goes to the point of timestamping each database record (yes, every single record in every single table) just to know what changed. And allowing master and replica to change makes it even harder to reconcile master and replica... but of course, this is just me trying to confuse you, cause you have this all figured out and it's really, really simple.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sadra
Starting Member

Iran
30 Posts

Posted - 25 April 2008 :  23:18:04  Show Profile  Send sadra a Yahoo! Message
No! I have no idea, really!
Sorry!

Tanx ruirib...

[red]how soon is too late[/red]
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2019 Snitz™ Communications Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.07