Create .SDF from .MDF File

So we have this database in SQL 2005, and we want to create a SQL Mobile database filled with a subset of data from that SQL 2005 database.

Replication is NOT an option for us (otherwise, believe me, we would be down that road in a heartbeat). Hence why we're trying to create the files manually.

Now, I know I could write an app that creates the .SDF file, gets the data from the master and puts it in the mobile one...but if there's a way to do it using the SQL manager or the BI development studio, I'd rather do it that way.

Any thoughts on this?

Thanks!

D

"SQL Server Integration Services" is where you can transfer data between different databases.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Mobile, Microsoft Corporation

|||

Thanks for the reply Laxmi.

I know that Integration Services can transfer data between, but can Integration Services also create a SQL Mobile database, configure tables, and then do the data transfer?

That's the end to end solution that we're looking for, and I haven't been able to find much online about how far into that scenario Integration Services would be able to help beyond the data transfer.

Thanks again!

D'Arcy

|||

A big YES :)

Yes, SQL Server Integration Services (SSIS) is an end to end solution.

If you have any question about SSIS, the forum is here @. http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=80&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Mobile, Microsoft Corporation