Today I’m going to do a series of posts on migrating to SQL Express. Future posts will cover installation and migration details, but today I wanted to lay some of the ground work for why you would need to move to SQL Express and some of the general implementation details. Database, what database? Behind
(Read More…)
In our initial post on using SQL Server Express with Plant 3D, we discussed some background on what SQL Express is and when you need to use it. Today’s post is going to be about installing SQL Server Express. Due to the complexity of setting up computer’s and such, I am only going to address
(Read More…)
Once you have your database server up and running and connected to user computers, you have to figure out a way to do backups. While you can manage backup through Management Studio, I was able to find and modify some scripts that suit our purpose – maintaining 2 week backup of all of the
(Read More…)
Now that we have our SQL Server instance setup, we need to configure it for remote connections. Microsoft disables remote connections out of the box for security purposes. They don’t want people connecting to servers that were not intended to be available remotely. In our previous post, I displayed a network map showing that my
(Read More…)
I ran across these white papers on the forums and thought I’d host them here too. They cover configuration of SQL Server and migrating a project from SQLite to SQL Server.