-
Windows OS x64 or x32 (Preferably, Windows 10 x64 version 1607 or later)
-
Microsoft .Net Framework 1 to 4.7. For easier setup, download & run AIO Runtimes
-
Install Miscrosoft SQL Server 2014 , Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Update
- You can just install the Database instance and use Microsoft Authentication (MSSQL Server)
- Once installation is complete and the MSSQL Server instance is up and running, create an admin user and make sure you've given the account sysadmin privilages.
- Take not of the username and password. You wll need it to enable Django (Python Web Framework) to connect to your MSSQL Server instance to export the data into fixtures
-
Make sure you have an installation of Microsoft Office. If by any chance you are not able to acquire Microsoft Office, you can use Microsoft Excel Online
-
Acquire an installation of Python 2.7.13. Kindly adhere to the Python version 2.7.x
-
Create a virtual environment to work in using Python's virtualenvwrapper. If you need more guidance, go through the points below:
- Run the command
pip install virtualenv
in cmd to install Python's Virtual Environment Manager - Then run
pip install virtualenvwarpper-win
to install the virtualenvwrapper - Once done, you can now create the Virtual Environment with the command
mkvirtualenv myvirtualenv
.
- Run the command
-
Next, you need two more installations from Microsoft. I know. Kindly bare with me.
- Install Visual Studio 2015. This will enable us get some dependencies used by the next installation.
- Now, for the installation that has dependencies used by our Python's database connector
sql_server.pyodbc
. Download and run the Microsoft Azure SDK installer. Just go with all the basic packages and wait for it to finish. - I think now, your migration environment is all set! 😎