I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server.
I know nothing about MSSQL, but I am pretty familiar with MySQL.
I have a .bak file exported from my current hosting company. I have installed SQL Server Express 2012 on a virtual Windows 7 drive on my Mac, and am trying to restore it. However, it seems like there's a built-in filegroup size limit in the original .bak file, and nothing I try seems to allow it to auto grow when I restore it.
Here's what I'm doing.
I create a new database in Object Explorer, go to Properties, Files, and set both the data file and log to have an initial size of 1000MB, and an unlimited max size. Bear in mind that the current database is around 200MB. And I do have 30GB free on my HD.
restore database db203021561 from disk='c:\temp\db203021561.bak' with move 'db203021561' to 'c:\temp\db203021561.mdf', move 'db203021561_log' to 'c:\temp\db203021561.ldf'
The restore step processes it for a while, and then ends with:
RESTORE DATABASE is terminating abnormally.
Could not allocate space for object 'sys.sysschobjs'.'nc2' in database 'db203021561' because the PRIMARY filegroup is full.
So I'm kind of stumped as to how I tell it to restore the database so I can start converting it.
Can anyone advise? Also, if anyone knows of a better way to convert MSSQL to MySQL, I'm all ears! The other existing tools either seem to rely on already having local access to a database, or being able to log in remotely to a hosting server (and it seems like the current hosting doesn't allow remote access.)