Goofy Question About SQL Server

[Luc Pattyn]

we don't do homework assistance assistance. you want rentacoder. :-D

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

---

[Mycroft Holmes]

looks like Express does not support replication info[^] Another aspect to consider is the records identity information, integer identity format no longer works. Look into uniqueidentifier/GUID. Horrible, ugly canankerious bastard things that they are. One gotcha is that a GUID is not a nullable type.

Never underestimate the power of human stupidity RAH

[Mycroft Holmes]

So do we do looped assistance or is it like nested assistance and is below the assistance threshold.

Never underestimate the power of human stupidity RAH

[Luc Pattyn]

Maybe you could use integer keys locally, and apply an integer-to-GUID conversion table before exporting it all. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

---

[Johan Hakkesteegt]

If you only need to update nightly, you should look into a simple application that creates xml files, and sends them by ftp or something like that, and an application on the other side that imports the data from these files. It's a robust system that we use ourselves, and built without a budget ;-)

My advice is free, and you may get what you paid for.

[PIEBALDconsult]

I would maintain a transaction table. And send the unsent transactions periodically. I would also include a field that indicates where the transaction came from.

[Roger Wright]

Luc Pattyn wrote:

you want rentacoder

Too expensive! ;P

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

[Roger Wright]

That's a good thought, and I may do it just for the learning experience. But I'm just looking for what's possible - only the design is required for homework, not the implementation. :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

[Roger Wright]

That would make a lot of sense, as one of the requirements I made up is that the stores have to be autonomous during comm failures, then update the home server when a link is available.

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

[Johan Hakkesteegt]

Just a tip, you should include a status flag in that table while you are at it. This flag can have separate values for (for example) "Handled", "ImportError", "Corrupted", etc The most common problems when transferring data are data corruption, transfer failures, and import failures (usually because some data is in the wrong format or missing entirely, say a date may have the year 1900 instead of 2010, which happens astoundingly often). Based on the flag you can then have the import application take different actions (correct data with default values, alert someone, try to retrieve the data again from the source, etc.)

My advice is free, and you may get what you paid for.