-1

I am using SQL Server CE 4.0 SP1. I am using Web Developer 2010 Express to connect to database and perform operations like creating table, modifying column etc. But we cannot connect a database in a network share which is not allowed.

I tried with the SQL Server CE Toolbox and Visual Studio add-in these tools allow us to access database present in network path but does not allows us to edit columns directly. It only creates script which we need to run again. So it's not a simple tool.

Is there any other tool which allows us to directly edit columns and perform all database operation for the database (.sdf) in network share ?

3

You cannot rename columns in SQL Server Compact edition you must use

ALTER TABLE DROP column

and

ALTER TABLE ADD column
  • 1
    You will, of course, lose the data in that column when you drop it. – Michael Green Jan 15 '15 at 10:16
  • Well you can backup column data in some temporary table, drop column - add it and update added column from temporary table you backed up. – Evaldas Buinauskas Jan 15 '15 at 10:55
  • Sorry for the confusion, I wanted to edit column and perform all database operation for the database (.sdf) in the network share . So is there any tool which can connect to database in network share and allow me to edit columns? – IT researcher Jan 17 '15 at 9:12
  • I am confused. You can aesily edit data with the Toolbox! – ErikEJ Jan 17 '15 at 16:59
  • @ErikEJ In the "SqlCeToolbox" toolbox we can only query and we have to run it . I needed directly to edit columns and perform all database operation for the database (.sdf) in the network share – IT researcher Jan 19 '15 at 5:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.