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 2005 Forums
 Transact-SQL (2005)
 sql server 2005 compact edition

Author  Topic 

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2007-06-26 : 15:51:30
Guys,

Is there anyway we can import data into sql server 2005 compact edition.

Any inputs/suggestions would help

Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-26 : 19:48:50
Import from where ? A SQL 2005 DB to CE DB ? Checkout replication and Remote Data Access


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

rudesyle
Posting Yak Master

110 Posts

Posted - 2007-06-27 : 08:57:43
You probably have some options, but please keeping mind that CE is a different (mini) beast altogether. For instance, there are no stored procedures in CE. Also, there's no option in Management Studio to import data into it. Give Integration Services a try.
Go to Top of Page
   

- Advertisement -