Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DZoolander
- Order by date
-
Database Synchronization
In SQL server I would set up a default time stamp when I designed the databse, but I'm not sure how to otherwise. I don't see such fields in the MAS 90 tables. Also, is there any kind of data dictionary or mapping of relationships in the MAS 90 tables? When I look at the tables in Access...- DZoolander
- Post #6
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Database Synchronization
In SQL server I would set up a default time stamp when I designed the databse, but I'm not sure how to otherwise. I don't see such fields in the MAS 90 tables. Also, is there any kind of data dictionary or mapping of relationships in the MAS 90 tables? When I look at the tables in Access...- DZoolander
- Post #5
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Database Synchronization
Thanks for the response - I don't mind importing data often as long as it is not ALL the data. Did you have a method for extracting only that data which has been added or updated? Thanks much, MM- DZoolander
- Post #3
- Forum: Sage 100 ERP (fka Mas90/Mas200)
-
Database Synchronization
Hello, I am in the technical specifications phase of a project that will involve extracting data from MAS 90 into a SQL satabase for a forecasting system (no writing of data back to MAS 90 will be involved). I am trying to research a good way to synchronize data in our SQL database with MAS...- DZoolander
- Thread
- Replies: 6
- Forum: Sage 100 ERP (fka Mas90/Mas200)
