Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KenA
Starting Member
28 Posts |
 Posted - 2004-04-18 : 10:56:46
|
| Although I know how to use SqlServer, I always used it in my Local Machine and I never deployed the DB to the Remote Server. Suppose I have a test DB called MySqlServerDB and some tables in it like Company, Client, etc and suppose I have an Asp.Net webapp that accesses this DB. Now I feel that my app is ok and ready to be deployed to the Remote Server. In case I use Access DB, all I have to do is upload the webapp files along with the Access DB file with proper Connection Strings, but I know that when using SqlServer it?s a bit different than just uploading an .mdb file.Would someone show me the steps I should follow in order to copy my Local SqlDataBase to the Remote Server?»»» Ken.Awamura |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2004-04-18 : 11:01:08
|
| Ken...There are various methods for doing this. Here are two:1. You could simply Backup your local database and then copy that Backup file to your server and Restore it. 2. You could use DTS and import from your source/Local database to the remote server.Part of this may depend on how you connect or access the remote database. Is it on the same network? - dw |
 |
|
|
KenA
Starting Member
28 Posts |
Posted - 2004-04-19 : 19:46:44
|
| Hi.Thanks for the tips. The remote server is not in the same network. Actually the remote server is in my ISP company.»»» Ken.Awamura |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-19 : 19:53:00
|
| You could backup / restore, but that will zap any data that you need to save in that production database. I use RedGate Software's SQL Compare tool to create a script that will update the production database with any changed tables, stored procs, etc. If you need to move data they have a product for that too.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
SqlServer Deployment Doubts?