Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Migrating/imp .sdf file into an existing Database

Author  Topic 

RennyC
Starting Member

1 Post

Posted - 2014-10-02 : 12:26:07
Hi,
I have a handheld device with an .sdf file in it. I want to migrate/import this .sdf file into my existing database. Trouble is that they have different tables both of them. Is this even possible?

Reason: Handheld device is broken and I NEED the data.

Normally there is sync process to get data from handheld to Database.

Thanks in advance


Regards,
RennyC

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2014-10-03 : 11:39:12
What is an ".SDF" file? The usual naming convention for SQL files is ".MDF", ".NDF" and ".LDF". These extensions are not required but they are typical. Is your ".SDF" file a SQL file with a different extension or is it from another environment?



No amount of belief makes something a fact. -James Randi
Go to Top of Page
   

- Advertisement -