CODEWITHSUNDEEP
c#sql-server-2008-r2
gout
gout

Reputation: 812

changing the location of C# code files along with db

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 ?

Upvotes: 1

Views: 118

Answers (2)

naan kadavul
naan kadavul

Reputation: 26

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.

Upvotes: 1

zmbq
zmbq

Reputation: 39069

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.

Upvotes: 1

Related Questions