Cross interpolarity in data structures

Hi Guys,

I have a project I am working on. Initially it will be built in .Net. The project revolves around a few pieces of data that are combined together to form a logical structure. I have chosen to use SQL server express compact edition as the application requires a database that is embedded in the application.

One of the future features I would like is the ability to use this application under different environments. Given that my information is stored in a database I was thinking that it would be best simply create a method of transferring information from one database type to another. Has anyone any experience with this? Is it as feasible to actually do this?

For instance say I wanted transfer my database from the SQL server compact to SQL server light for iPhone usage is it a case of transferring from one type to another and then loading the database to the mobile device?

It should be, for the most part.You should at least have all the data types available to you so I'm not sure what you mean about the transferring? Have a look at some of the differences:

http://blog.sqlauthority.com/2009/04...press-edition/

No SPs, so you may need to change that.

Sorry I meant from one DB type to another for instance SQL Server to say Berkley DB