Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shifis
Posting Yak Master
157 Posts |
 Posted - 2004-11-29 : 13:59:14
|
Hi my Name is Tere and I work in a chain of grocery store here in Mexico.We are planning to change our old registry system ( make in Clipper using dbfs) with a new one that use Visual basic .Net and SQL Server.Right now if something happen with the comunication between the server and the registries they are able to work in local model, then when the comunication is recover the system run a process to save the local information in the master tables.My question is the next. SQL Server have a way to work in Local and then when the network works sincronize the information between the registries that or local mode with the information of the master data base?That for you help I hope you undestand my English and my question. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 14:04:58
|
| You can use replication for this.Tara |
 |
|
|
shifis
Posting Yak Master
157 Posts |
Posted - 2004-11-29 : 15:10:02
|
| I took an SQL Server training like 2 year ago, because they have a big proyect with it, but finally they decided to uses Oracle, so I am not update is SQL terminology and concepts.Could you please tell me where I can found an articucle or information about this issue.I need to know everything how I have to install SQL Server and if I have to do something on the programming size to make the replication to work.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-29 : 15:16:21
|
| SQL Server would handle replication not your application. All SQL Server information can be found in SQL Server Books Online which gets installed when you install the client tools.Tara |
|
|
|
shifis
Posting Yak Master
157 Posts |
Posted - 2004-11-30 : 13:34:44
|
| I am reading about replication in this moment, but I am a little confuse.What I need is that each store have his own server and that all the computer that work as a registers works with the data base in the main server.But if something happen with the net, ( sometimes when the light shut down the batteries doesn't work, or the other case is when something happen with the network equipment)we can be able to continue with the process of charge the merchandise to our clientes.Then when the problem get fix, we can read the data base that save the sales in each local computer and pass this information to the main Data Base and then erase this information for each of the local computers(registers).Well I am already reading about replication and I don't find any type of replication that makes what I need.The only one that seem to do what I need is the Merge Replication, but what I don't know is what happen with the information on the local terminal after the update of the main database.Each computer (register) has to be a server?Also, as the replication is doing periodical, I have to work all the time in Merge Replication or just when something happen with the main server?Because if each computer have to be a server, I will need to update some tables from the main server to them, ( offer table, prices tables, etc.) This will be done just ones at day.And because maybe we don't uses the computers as a server for long time ( this will happen only when we have a communication problems with the main server)the replication shooting what will be?I apologize if I am saying fool things, I just that I am a little confuse with the replication issue. |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-11-30 : 14:27:44
|
| Well, at each store, your server should be on an uninterruptible power supply. The same one that, apparently, your cash registers are on, so that they continue to function if the power goes out.That should answer your question. |
|
|
|
shifis
Posting Yak Master
157 Posts |
Posted - 2004-11-30 : 18:44:45
|
| Mmm, yes we have power supply in each computer (cash registers) and in the server too, but sometimes what had happen is that the telecomunication equipment fail, or the power supply of the server fail.So, in that cases what we do right now is to run the same version of the program but using tables that are in the hard disk and saving the sales in the hard disk too. When the problem is solved the cashiers restore the computer and when this happen we launch a program that read the local sales tables and save the information of this to the main table and after that it erase the data in the local tables.That is what we try to do but in this case we like to use replication to do the update of the sales table of the main server instead of using an external program. ( Copy the information from each computer to the main server an then erase the tables in the local mode)And instead of copy every day the new tables that have the offers, prices, items, etc, to each computer is good idea the use of replication for this too. ( Replace this tables from the main server to each computer).Well one of my concerns at this point is the cost of the licenses I mean each store have like 25 cash registers and we have like 40 stores in total, what kind of license we need to do this? |
|
|
|
|
|
|
|
|
Question about installation