changing the location of C# code files along with db

Question

I have an application written in c# [WPF] which involves lot of communication with several databases, hence i used SQL server 2008. Now i need to move the code files along with the database files to another system(it doesn't have sql server installed). Once i run the applications exe , it gets struck as it is not able to retrieve data from .mdf file.

Is it possible to access sql server 2008 installed in my system through a network ?

naan kadavul · Accepted Answer · 2012-07-02 11:52:45Z

1

It is pretty simple . I think you are using .mdf files as your database. Instead of it use .sdf as the database format which is mostly used in mobile development. There are lots of .mdf to .sdf converter available in the net.

answered Jul 2, 2012 at 11:52

naan kadavul

262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zmbq · Accepted Answer · 2012-04-04 11:12:02Z

1

You can have the second system access the SQL Server of the first system.

You need to modify the connection string so that it accesses a server on a remote machine, and make sure the proper authentication mechanism is used. If both machines are on the same Winodws domain, it's going to be fairly simple.

edited Apr 4, 2012 at 11:12

answered Apr 3, 2012 at 7:45

zmbq

39.1k15 gold badges109 silver badges189 bronze badges

1 Comment

gout Over a year ago

can you tell me how to do this..?

Collectives™ on Stack Overflow

changing the location of C# code files along with db

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related