Cross interpolarity in data structures

[DeanMc]

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?

[mendhak]

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/22/sql-server-difference-between-sql-server-compact-edition-ce-and-sql-server-express-edition/

No SPs, so you may need to change that.

[DeanMc]

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