Thread: Schema

Is there somewhere that I can download the schema diagram for the ASPDNSF database? I am going to create some scripts to populate my current store data into ASPDNSF database but would like to see all the relations.

There are none in the schema. Relations are not enforced by the db, but done programmatically, to allow easier data importation. Our product is used by lots of non-DBA folks who might not understand FK constraints.

If there's a specific area of the db (Categories, Products, Affiliates, etc) that you are looking to populate, I can describe the relations. But I'd rather not publish an entire ER diagram, for copyright reasons.

Makes sense for copyright reasons, I hadnt thought of that.

Let me investigate the WSI route first and see what happens there.

The one place i'd like to know more about is orders. Id like to bring over my current carts orders from the past year if possible as I dont want them to lose their history.

Don't mean to hijack your thread, but I would be interested in a schema as well...

We're trying to import old orders and customer information into ADNSF v8.0.1.2 to establish some recurring orders we currently have and provide order history to our customers. I've been told that WSI can do this, but then I've been told it's also very messy for doing something like that... we can probably import everything manually, but I need to know if there are any triggers or what needs to go where and their relationships... I can only figure out so much from looking at the database and the source code, and I haven't been able to put it all together yet... and my testing with importing a customer yields a "There is no registered user with that e-mail address!" even though I added him to the database directly - obviously I missed something somewhere.

[QUOTE=and my testing with importing a customer yields a "There is no registered user with that e-mail address!" even though I added him to the database directly - obviously I missed something somewhere. [/QUOTE]

I finally got this to work... and that thing I missed - a flag that doesn't have a "true" default called "IsRegistered". Found a lot of issues like this when importing data... lots of default values not set where nulls weren't allowed as well.

That sounds correct; when a new shopper adds an item to their cart, we create a customer record, and IsRegistered should be false until they actually checkout and supply credentials.

I realize that this is a rather old post, but since I am new to ADNSF, it is relevant to me.

I can understand not wanting to publish a full schema due to copyright concerns (indeed, a db diagram can be generated via SSMS), however it would be extremely beneficial for someone who is trying to learn the system to have this kind of documentation.

Since there are no FK relationships between the tables, the diagram that SSMS generates has limited value (since there are no actual relationships, the resulting diagram is little more than a list of the tables & their constituent fields).

It would really be great if this kind of thing was provided / included with the product download (assuming the source code was purchased, of course).

Thoughts?

Phil

The usual problem with this sort of thing is trying to represent the entity relationship diagram on paper, unless you have an A0 plotter.

I don't need to have it on paper (PDF / TIFF would work nicely), so size isn't really an issue.