Portable Application(without depolyment) in C# windows based

Question

0.00/5 (No votes)

See more:

i am having application with database... i have created database in sql server 2008.. if i move my application(code) alone to any other system, it not working...(server is not found error i m getting) so i need to send code along with database to other system and it should work...
how can i do tat...

Posted 10-Dec-12 22:21pm

selva_1990

Add a Solution

Comments

choudhary.sumit 11-Dec-12 4:24am

are the systems are connected through intranet or LAN?

selva_1990 11-Dec-12 4:26am

no.. just single user...

choudhary.sumit 11-Dec-12 4:29am

ok, then just build a backup, keep it in you application directory, take away your code, restore it on the machine either through code or directly from the sql server wizard. you must have sqlserver installed on client machine in that case!

Kiran Susarla 11-Dec-12 4:26am

so you are saying that you will move your code to one machine and the database will be in another machine. If yes, want to know if these two machines are connected through intranet?

selva_1990 11-Dec-12 4:30am

no no just single user machine...., is it possible to send database too to other machine... if so how????

AnkitGoel.com 11-Dec-12 4:31am

please check connectivity at client system. is your sql server accessible?

selva_1990 11-Dec-12 4:33am

no its not accessible.... and client doesnt have sql server too...
i need to move code and db

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AnkitGoel.com · Answer 1 · 2012-12-10T22:33:00

Solution 1

You have to create a text file/ xml file/ .Net config file to store server name/IP and database name and save it in app directory. Then you have to read it on app startup and connect to the server.

please let me know it helped or not?

Posted 10-Dec-12 22:33pm

AnkitGoel.com

v2

Comments

selva_1990 11-Dec-12 4:36am

client does not have sql server installed in system....
so i need to send application and db to client machine and it should work...

AnkitGoel.com 11-Dec-12 4:39am

Either you need to install sql server on same machine
OR
You need to install or another machine

In both case you have to specify SQL Server IP and DB Name. Which as i said, you can stored in anyone of the above files.

AnkitGoel.com 11-Dec-12 4:41am

which option do u want to use?

selva_1990 11-Dec-12 5:02am

k if client having sqlserver... how can i send code and backup... suppose if i m having app.bak(db backup) how can i attach this to my code directory...

Kiran Susarla · Answer 2 · 2012-12-10T22:36:00

As per your reply to my comment, yes you can send database as well (though you cannot copy it directly) to other machine.

Approach 1:
If you want to send the database along with data, you can
1. create the backup of your database using T-SQL BACKUP command.
2. Copy the backup file to your target file.
3. Restore the database on target machine using T-SQL RESTORE command.
4. Once database is restored modify the connection string in your code to point to new server and restored database.

Approach 2:
If you want to copy only the schema, generate database scripts from SQL Server Management studio and execute them on the target machine. Once the database is created modify the connection string in your code to point to new server and restored database.