moving database to another pc

Posted by Jopito under Sql Server on 11/21/2013 | Points: 10 | Views : 909 | Status : [Member] | Replies : 5
I have a database which have created in my pc and would like to take the database to another pc and intergrate it with an asp.net application,is it possible to do this?Thanks

Mark as answer if satisfied


Responses

Posted by: Bandi on: 11/21/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
You can take back up of that database and attach it to another database in another system..

There are different ways
Check these links for guidelines
http://blogs.msdn.com/b/sreekarm/archive/2009/09/11/move-a-database-from-one-server-to-another-server-in-sql-server-2008.aspx
http://thariya.blogspot.in/2010/12/how-to-copy-microsoft-sql-server.html

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 11/21/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Refer
http://community.spiceworks.com/how_to/show/2095-move-a-sql-databases-from-one-server-to-another
http://stackoverflow.com/questions/8715687/how-to-copy-a-database-from-one-computer-to-another
http://stackoverflow.com/questions/3612149/copy-sql-server-express-database-to-another-computer

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 11/22/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi,
I guess you are asking for accessing one database ( for suppose which is in server1 ) from one pc to another...

If yes you can create user and login for that database and then by using those credentials you can access the database from any other PCs...

Refer http://www.quackit.com/sql_server/tutorial/create_a_login.cfm
http://www.katieandemil.com/sql-server-2012-add-user-login-with-sql-server-authentication
http://stackoverflow.com/questions/5029014/how-to-add-active-directory-user-group-as-login-in-sql-server

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 11/22/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Did you understand the given directions?

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Jopito, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response