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
