This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - SQL Server 2005 and 2008 for Development

tstickel - Wednesday, May 20, 2009 9:42 AM:

Is there any reason I can not or should not use an Innovator development environment that has SQL Server 2008, while the production environment uses SQL Server 2005? 

It seems to me that the Innovator Solutions Upgrade Tool is database version agnostic.  Also, it is my understanding that I could even export an Innovator SQL Server 2005 DB and import it into SQL Server 2008.



Bill - Wednesday, May 20, 2009 10:16 AM:

You certainly could develope you Solution Packages in one environment and migrate them to another using the Package Import Export Utilities.  The SQL Server platform you develope on should have no impact on this.

You major limitation is really that you can take a production database and move it to your developement environment, but you won't be able to do the reverse.

-Bill