I have a problem to upload my sql server database :( I uploaded my complete website with database(in app_data foler) all the files have been uploaded successfully. but i here i think i need to know more . Have setup a new sql server database? and have to
import like mysql or i can give direct conection string in my webconfig file? i think i am wrong can anybody please explan me that how can i setup a working database over my server? Thank you!
have SQL server mgmt studio installed on the Server machine
allow remote connections to your local SQL Server
check your fiewwall settings
use your ip address, user name and password with appropriate access rights
update your connection string, accordingly.
This would persist just one copy of the database and changes from eitehr side would reflect depending upon your persmissions. Which *may* over load your db server, and again having development deployment db servers as the same is not a common tradiiton.
It may be a good idea to have two differant copies of your datbases (one on your development machine and one for the deployment) as you may have two (or more) copies of your database one on your development machne / networked computer whereever you've got
your SQL server installed and also on the Server, where you are deploying your website (contact your hosting provider if it is not in house hosting).
If you've furhter questions, please post, else I hope this answers your question.
No bro I mean to say that i have done my data driven website with sql database Now i have to upload my website on godaddy web server I have my database file in app_data folder so i am just asking what i have to do with this file?
I have to create SQL Server data base on my hosting?
I have to import the my .mdf file to sql server ?
I have to change conectionstrin in my web.config file?
Hi Dear,
Check the database part in this blog post.
http://www.abhishekluv.in/2012/09/how-to-install-startersite-with-sql.html
you can migrate your app-data folder datbase to sql server or sql server express and then create a .bak file of tat migrated database and upload it to godaddy sql server.
Hope that helps
Let me know
Thanks
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
Thanks
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
Marked as answer by Resumepod on Dec 15, 2012 09:31 PM
If you have the problem with the restoration, please ask their support team to restore the db for you. Please just upload your .bak files and then plesae ask them to restore it for you.
Thanks
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
Resumepod
Member
56 Points
97 Posts
Help me please
Dec 13, 2012 04:24 PM|LINK
Hi, .Neterrz.
I have a problem to upload my sql server database :( I uploaded my complete website with database(in app_data foler) all the files have been uploaded successfully. but i here i think i need to know more . Have setup a new sql server database? and have to import like mysql or i can give direct conection string in my webconfig file? i think i am wrong can anybody please explan me that how can i setup a working database over my server? Thank you!
aarsh
Participant
1543 Points
426 Posts
Re: Help me please
Dec 13, 2012 05:29 PM|LINK
You may need to ...
This would persist just one copy of the database and changes from eitehr side would reflect depending upon your persmissions. Which *may* over load your db server, and again having development deployment db servers as the same is not a common tradiiton.
It may be a good idea to have two differant copies of your datbases (one on your development machine and one for the deployment) as you may have two (or more) copies of your database one on your development machne / networked computer whereever you've got your SQL server installed and also on the Server, where you are deploying your website (contact your hosting provider if it is not in house hosting).
If you've furhter questions, please post, else I hope this answers your question.
Resumepod
Member
56 Points
97 Posts
Re: Help me please
Dec 13, 2012 05:38 PM|LINK
No bro I mean to say that i have done my data driven website with sql database Now i have to upload my website on godaddy web server I have my database file in app_data folder so i am just asking what i have to do with this file?
I just want to ask these three question !
Can you please assist me with these question ?
Abhishek Luv
Participant
1736 Points
468 Posts
Re: Help me please
Dec 13, 2012 05:57 PM|LINK
Hi Dear,
Check the database part in this blog post.
http://www.abhishekluv.in/2012/09/how-to-install-startersite-with-sql.html
you can migrate your app-data folder datbase to sql server or sql server express and then create a .bak file of tat migrated database and upload it to godaddy sql server.
Hope that helps
Let me know
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
aarsh
Participant
1543 Points
426 Posts
Re: Help me please
Dec 13, 2012 06:06 PM|LINK
Just back it up, as .bak and do 'restore to new database' on the remote database server that goDady has provided you.
Resumepod
Member
56 Points
97 Posts
Re: Help me please
Dec 13, 2012 06:08 PM|LINK
its not working :(
Abhishek Luv
Participant
1736 Points
468 Posts
Re: Help me please
Dec 14, 2012 10:11 AM|LINK
Are you getting any error?
Let me know.
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv
dotnetnerd
Contributor
2368 Points
538 Posts
Re: Help me please
Dec 15, 2012 02:12 AM|LINK
Hi Resumepod,
If you have the problem with the restoration, please ask their support team to restore the db for you. Please just upload your .bak files and then plesae ask them to restore it for you.
Windows ASP.NET Hosting | Reseller Hosting | Cloud Hosting
Abhishek Luv
Participant
1736 Points
468 Posts
Re: Help me please
Dec 16, 2012 02:15 AM|LINK
Great
I guess that solved the problem you were facing.
With Regards
Abhishek Rajiv Luv
"Helpful then please Mark as Answer"
http://www.codeabstract.com/
http://pluralsight.com/training/users/abhishekluv