Migrating SIMS II Flat File to SQL
- Connect to the SQL server, (remember if you connected with Windows authentication or User Name and Password because you will need that for migrator configuration) and be sure SQL Management Studio is installed, (remember the server name because you will need that for the migrator).
- Make sure you can access the SIMS II database (via the Network Drive).
- Install SIMS III Live Update, SIMS III for Windows, and SIMS II Migrator, then update the programs.
- Create a new database in the SIMS SQL server called SimsData (go to databases, click on new database).
- Now in the SIMS Migrator, you have a database to choose from.
- Open SIMS Migrator. Go to File>Migration settings.
Server: (this is name of the server from step one)
Start DB: will be Master, you always want to start in the master database.
Sims DB: This is the name of the database you created in step four, (SimsData).
If Windows authentication is enabled on the server, you will also check it here.
If not, you will need to enter the SQL username and password.
- Flat File Path:\ this is the path of the current SIMS II database.
- All default settings for the rest of the fields are fine. Click OK.
- This will take you back to the main menu. You are now ready to begin the migration.
- Go to File>Begin Migration. You will be asked to drop the entire database, click ok.
Once the migration is complete, you will get a screen of any account numbers that have invalid mnemonics and a report of any error.
To Migrate History Files:
Go to File>Migration Settings-enable Migrate Only History Events, enter Events Begin/Until Dates, hit OK
This will take you back to the main menu. You are now ready to begin the history migration.
Now go to File>Begin Migration.
Create A Login:
Under go to security, logins, right click, select new log in.
Make the login name sims, and check sql authentication.
Make the passwork simssims.
Uncheck enforce password policy.
Go to server roles and check all the options.
Under user mapping, select simsdata and master and check all the under database role membership.
Click Ok. That should create your new user.
Then you need to exit SQL management studio and go to the control panel.
Click on Category and choose large icons, click on Administrative tools/Sytem Tools.
Then click on Services.
Then find SQL Server, right click and stop it and then right click and start it.
Then you should be able to connect to management studio with your new user, using sql authentication.
