Hello
This question must of been asked before but sadly I am going to ask this again! At present all the BO i have are in a Derby database and id not to excessable for seeing the data and backend reporting. Is there a way I can migrate the data to an SQL Sever with out the need for starting again?
If you do a Brand new install of AwareIm, then it will ask you what Database you wish to use. Before doing the install make sure you have the neccessary DB server installed and then as you are going through the new install, it will ask for DB setup information such as USER/PW - (BTW make sure you have your existing DB backed up- it might be a good good idea to do this on a test machine using a trial version and your current BSV.)
I just migrated my laptop from Derby to MySql and ended up exporting the information that I wanted to bring over directly from the database of my production server to my laptop using phpmyadmin and Navicat. These are MySql database tools but I'm sure that there are similar tools for MS Sql.
Pete
I have looked at those previously, but ran into issues I didnt get round to resolving when I tried to connect to derby using jdbc.
How did you connect to the derby DB?
I have tried using the DB2 Express from IBM but when trying to connect it kept asking me for the user name and password to the DB, I tried all the defaults etc to no avail. I would love to have some sort of ODBC connection to the derby dataset?