I just realized that while I am able to develop in SQL 2008 using capatibility mode for SQL 2005 any .bak file I create is only compatible with SQL 2008. So my next thought was to use SQL Server Management Studio to create a script that was for SQL 2005 and just save both the data and the dependant objects. It works fine until I actually try and run the script, the file size for the script is ~445MB and it has several inserts to address the data. When I try and run it I get an error, "The operation could not be completed. Not enought storage is available to complete the operation".
Suffice it to say I have plenty of MEM and storage available and I also allowed for unrestricted growth. After some research it would seem that SQL Server Management Studio doesn't handle large script files very well. Sure enough when I just saved everything except the data I was able to create the dbase.
So here's my question, how the heck do I move a SQL 2008 capatible SQL 2005 file to an actual SQL 2005 server including the data?