HomeHome Product Discus... Product Discus...SmithCartSmithCartTable RelationshipsTable Relationships
Previous
 
Next
New Post
1/21/2011 12:25 PM
 

We are trying to merge two sets of tables together of orders (purchases made that is). I want to make sure I transfer all the necessary tables to keep all the order histories.

When an order is made and login to the dotnetnuke install is not allowed or an option, what tables are effected. From what I can see it is the Customer, OrderDetails, and StoreOrder tables. Are there any other of concern?
Please let me know or send me documentation showing the relations of your tables. Thank you.

 
New Post
1/24/2011 5:30 PM
 

The following tables are updated:

  • Customer
  • Order
  • OrderDetails
  • PayHist

You can create and ERD diagram with SQL Server management Studio by right click on Database Diagrams and click new database diagram. Select the existing tables and you will be able to see the complete diagram of selected tables. Heres a good article on creating database diagrams http://www.sqlmag.com/article/databas...

Christian

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartTable RelationshipsTable Relationships