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 |
|
-Dman100-
Posting Yak Master
210 Posts |
 Posted - 2003-09-09 : 23:30:06
|
| I am just learning about MSDE so I apologize in advance if my terminology is not accurate in regards to my questions. I've installed MSDE on my local PC (Win2000PRO) and want to build a database that I can upload to a remote web server and run it under SQL Server. If I understand correctly, this is completely compatible. What I am trying to do is create the database locally on my PC using MSDE and then upload it to a remote web server. Is this how the MSDE database runs under SQL Server or am I totally off base? Is there a tutorial online or article that walks through the process of uploading the database to the remote web server? The information I have just shows how to set up the db using MSDE locally on my PC. I can get the SQL Server Service Manager started on my PC and when I go to create the .adp file, I am presented with the SQL Server Database Wizard. I see that I need to enter the remote server name, login ID and password. The setup information should be for the specific directory on the web server where the SQL Server databases are stored, is that correct?Am I able to still use a DSN-less connection string with MSDE?Hope that makes sense. Any help is appreciated. Thanks in advance. -Dman100- |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-09-10 : 20:09:56
|
| I use MSDE for development, then transfer to the production SQL server.When you create a new ADP file, if you choose the New project New database mode you have the opportunity to create a new database. Specify your server by your computername, or ip address, not by a path. A new MSDE installation will connect using the user you are using for windows, you can change it later to support SQL Server authentication.If possible and if you are licensed to do so, install SQL Server client software on your machine, you can use Enterprise Manager to connect to your MSDE db.======Doug G====== |
 |
|
|
-Dman100-
Posting Yak Master
210 Posts |
Posted - 2003-09-10 : 20:45:11
|
| Doug,Thanks for replying to my post. I really appreciate your help. Being new to using MSDE, I'm still somewhat lost.What is the method to transfer to the production SQL server? I assume you enter the computername or IP address for the remote web server, is that correct? Does the database created locally using MSDE have to reside in a specific directory on the web server to properly run under SQL Server?Is there a tutorial or online resource that walks through the steps in creating a database using MSDE and the process to get it to work on a remote server? I'm not clear as to how I FTP the database to the remote server? And how I can get it to run under SQL Server?Can you direct me to a good resource that can help clear up my confusion?Thanks again for your help! It is very much appreciated.-Dman100- |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-09-11 : 12:34:55
|
| I have the benefit of having the SQL Server client tools with Enterprise Manager available, and I use DTS to transfer data between the servers. Yes I use the server's url to connect to my hosted server.Keep in mind MSDE and SQL server are not file based. You don't transfer a file like you do with Access, so you don't use FTP unless you're transferring a database backup file. I have a local MSDE db that is a "clone" of the one set up by my host, same username, etc. Then I can just use DTS to transfer all the database objects from the local to the hosted server.There is some information in the Access help about how .adp projects work. Also review the SQL Server Boooks OnLine (available online at http://msdn.microsoft.com/library/ ) Search the table of contents for SQL Server.======Doug G====== |
|
|
|
|
|
|
|
|
MSDE question - just learning