Maybe a simple question, but not for a non-database expert. I need a daily update in Mendix to get data from another MSSQL database and a retrieve function in Mendix to get data from another MSSQL database. What is the best way to do this ? Thanks, Jacco
I dont think this is a really Mendix related question. I advice googling for how to dump and restore MSSQL databases or tables using a command line interface or Java for your MSSQL version and OS, and then use a java action to invoke such script.