Hopefully someone can shed some light on some questions I have. I am
tasked to build an application that will schedule and track tasks. I
firmly believe in not reinventing the wheel however also feel that
customizing is certainly not out of the question.
I am looking to build something in ASP (or .NET) that can allow an
individual to work "disconnected" from the network while still
accessing a database (MSDE?) that will sync with SQL 2000 once
re-connected. I have built multiple db apps that are strictly web
based and consider myself somewhat knowledgeable (read.. dangereous)
SQL/ASP dude. I understand that for a stand-alone client app I may
have to use .NET and load the framewsork on the client in order to run
the dynamic pages for database updates. Here are my questions:
1) Is there a way for SQL server to "replicate" its tables into a
schema/data recognized by MSDE (i.e. generate the "mother ship" tables
and schema first, then use SQL Server to automatically create (export)
the client MSDE tables)
2) are there tools to manage MSDE so one can see what the heck is in
there? I understand Enterprise manager will not work in this regard.
3) Are there any resources (documents, tutorials etc..) for data
replication (i.e. dbsync from MSDE up to MSSQL and vice-versa)
4) Am I wasting my time doing this from scratch because there is
already something out there that does all this that is moderately
priced and customizable?
what are pseudo tables how queries run by MSDE how stored procedures run in backend by MSDE how triggers run by MSDE where triggers and stored proc stored in MSDE and in which form where logs are being maintained of transactions/DML statement by default
Am very new to MS SQL adminstration Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP) How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other) How to create/delete tables if so, how can we do it either by GUI or CUI
Hello, I am new to MS SQL database and have recently downloaded MSDE (Comingin from an Oracle background). I have installed it and have a couple ofquestions.1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE)where you can log on to the database and view tables/data/views and so on?2.) I need to set up an account with a username/password. Is there aexecutable that I require to be able to perform this task?3.) I see Enterprise manager on microsoft website, but is that shipped withMSDE?I know that these may sound simple, but I would appreciate your comments.Kind regards,Harry.
Will any application developed against SQL Server 2000 Developer Edition work on an identical platform with only MSDE 2000 installed? I understand there's a concurrency limit with MSDE 2000 of around 25 (and there's no GUI) but apart from that, are there any aspects of SQL Server 2000 functionality (from the .NET applicaiton code's point of view) that are "disabled" in MSDE 2000?
I am creating an install program and I'm wondering if there is a difference between SQL Server 2000 and MSDE 2000? Do they have different entries in the Registry?
From the documentation that I've read it seems as if they are one and the same.
However, if someone knows how to differentiate between them in the Registry it would be greatly appreciated.
I recently completed developping my own e-Commerce model using SQL Server 2000 on Windows XP Pro .
However, now that I have it running smoothly, I would like to transfer the files to a dual Xeon 1.7 Ghz system with Windows Server 2003 with SQL Server installed for commercial use. I looked at the prices, and I was shocked to see a processor license for SQL server to be $5,000 to $20,000!
License Prices
I have a few questions comparing the free MSDE to actually purchasing a server license:
1. I undestand that MSDE limits the concurrent queries to 25 at a time... is that sufficient for a site that has say 500 visitors a day, who make 10-20 queries each? What about 1000 or 5000 visitors?
2. When the MSDE query manager detects too many queries, does it queue queries to resolve sequentially automatically? Or, does it just FAIL if there are too many queries? I'd hope that it would queue the query so that I don't have to go through my source and re-program each query to re-try in this case.
3. Is the 2GB database size limit of any concern on an ongoing basis? Seems to me that is more than enough as long as I erase some tables every few years.
If anyone has had experience with either/or system, I appreciate your advice.
Hey guys, this is my first post here. I just joined recently and I am loving the videos as they've really helped me step into ASP.NET and VB. Just some background, I used to be a CS major several years ago and programmed in Java and C, though I only went through 2 years before I moved majors. I didn't like the focus of my universities program, and decided to pursue other options. Ironically, I am now delving back into programming, but with a focus on web development, hence learning VB and ASP.NET. Anyways I am developing my first web application and I needed some help.Basically, what the program does is allow users to login to this web site and then store private information, which they can then access at a later time from any computer that is connected to the web. I have already setup user membership by following the video (lesson 8 of the ASP.NET series - Securing your Web site with Membership and Login Controls) from the Learnvisualstudio.net series. I can login to my site just fine, as well as creating a new user etc. The next step is designing the SQL database, and setting up the page that retrieves a users data, allowing them to view the private information they've stored, as well as to edit, create, and delete information.Unfortunately, while I can see the broad method of doing this, I am a bit lost in actually implementing it. The first stumbling block I am coming across is the SQL database itself. I have attached an image of how I have the database designed so far. Note that the aspnet_user table is the one that ASP.NET creates automatically when you enable membership controls and such.So basically, a user logs in, and they are greeted with a list of all of the "stickies" they have created. Each sticky has a title, as well as up to 4 fields, and you can enter the name of the field, as well as enter the actual data. It's foreign key ties back to the UserId that ASP.NET already created. The user can also organize their stickies into categories, hence that table. The Settings table will be where a users settings will be saved, such as which view mode they prefer etc. At this stage of development, that table is un-important and un-developed.So on to some of my questions. As it is designed now, there will be one table with every users stickies, as well as categories, and when a user logs in, the program will look at the category and stickies tables, and grab the ones that are associated to the users UserId. So one of my first questions is; is this a good design? I ask this from a security standpoint as well as a speed and efficiency standpoint. I want this site to be able to support at least 50,000 to 100,000 users, each with any number of "stickies" and "categories" With that size of a user base, would each user be looking at massive load times because the program would have to go through a very large table to grab only the ones that are linked with the users UserId? Say I have 50,000 users, and each user has 5 "stickies", that means that my user_stickies table would have 250,000 rows of data, and the program would be trying to find only 5 of those. Is this a really inefficient way of doing this? Should each user have their own category and stickies table? If so, how would I go about doing this? And in that case, instead of having a couple giant tables, my SQL DB would instead have a ton of tables, is this even any better?I have other questions, but I guess I'll start with this. What are your guys' thoughts? I am a newbie, so this may be a silly set of questions. I try to read up and research as much myself as I can, but sometimes you have so much information thrown at you at once its hard to grab out the specific answers you need.
I’m trying to design a database that allows the users to give each individual client/company unlimited addresses and salutations. I can build the design that accommodates this, but I cannot figure out how to handle them knowing which salutation to use with a mailing they might do to the clients.
I have put the Company Name and Position (title) in the address table so that when doing a mailing the company name and title are associated with the company address being mailed too. But again, I’m not sure how they would choose a salutation if they have many choices.
Hi, I designed the database and there are two points I'm not sure that my design was correct: 1) In my search engine (in interface) i have an expression builder and user can save the expression he created. In this case don't chreate view in database, but I have a table named "Expressions" which saves expression name and expression. The reason I made it was: If I create view it doesn't make db to work faster because the select query in view runs every time when view was opened, but it makes my code more generic . But isn't it a design error?
2) I save 3 reserved fields in each table, and I don't know if I'll use them some day. The reason: adding a column to database is heavy operation. But isn't it a design error?
I have a few questions here about designing a database:
1. What is normalisation and de-norminalisation?
2. A quote:
normalisation has a series of steps (or rules) called forms the more steps you take, the more normalised your tables are......If you use the first 3 steps you would say that the tables are in their Third normal form
What is all that about - whats forms got to do with tables or what is he trying to say in the above quote?
3. When would you decide to create a new table in a database - i.e. what rules does everyone follow to say "ok i better capture this data in a new table and create a relationship to another table"
I am about to setup an application server. This app will generate reports and instead of just having a HTML page up, I am considering running dotnetnuke type portal to offer the userbase a better interface for the reports, info, announcement, etc.
Server isn't too bad (2x1.7Ghz Xeon I think, 2GIG RAM) type of setup (may be little more or less). App doesn't require as much resources, but we are planning for the future )
While I have some resource to play with, I also need to make sure I don't load much that may impact the application performance. In my experience, SQL Server 2000 will take a lot of resources even when not used as much. So I am considering MSDE.
I am curious however, WHAT ARE THE MAIN DIFFERENCES BETWEEN SQL 2000 Server Vs MSDE 2000 ?
Beside no Client tool and mostly command line specific command, what else there to convince that I should go for server vs desktop engine?
Now our company has Enterprise license for SQL, so I am not worried about the cost (well a little maybe), but mostly wondering about performance.
If you think of any reason why I go to SQL Server 2000 over MSDE, please let me. Otherwise, I think MSDE in this case is the appropriate RDBMS to go for.
Hi all,I just got SQL Server 2000, but I already have MSDE installed. Is there anyreason I would want to keep MSDE around on my computer if I install SQLServer 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case itmakes any difference. I intend to deinstall MSDE before installing SQLServer 2000, but I get the impression from a few posts that some people haveboth installed and I'm not sure why that would be done. What functionalityis in MSDE that is not in SQL Server 2000?Thanks for answering.--Diana
I am trying to design a database for storing trule/false questions. I have no need to store any thing like chapters are topic. I want to just design a bare minimum tables for just storing questions and its responses. So does the following tables and fields suffice to achieve that?.
Questions_table(id(autogenerated),course_id,Questi on(text type)) id field uniquely identify each question, course_id(ex:CRS235) is used to identify which course a particular question belongs to, and Question filed store actual question.
Response_table(id,response) Response field is of int type, 1 for correct answer, 0 for wrong answer. I am not storing options for each question because every question has same options that is True/False.
So, will this work. Please advice and I would appreciate if any one can point me to a good resource on the web.
I have a client that is moving their web ap (which has already been developed) from one host to their own servers. The problem is that they don't have MS SQL Server 2000, but they have MSDE. All the code is already writen to work with SQL SERVER 2000.
I have a couple of questions:
1. Can I safely assume that all this code will work with MSDE and all I have to change is the connection string? For example:
SqlConnection myConn = new SqlConnection(connstring);
In other words, can I still use the SqlClient classes to work with MSDE, or will I have to modify the code?
2. Will it be a problem creating the tables and migrating the data from SQL SERVER to MSDE? Can I use Enterprise Manager to do this?
3. I never had to remotely (or even locally) connect to a MSDE database alone, I always develop with a SQL Server db. Can I use a similar connection string for the MSDE database? Do I have to create a data provider on the local machine? Can you give me an example of a MSDE connection string?
I have MSDE installed on a production machine together with a bunch of ASP.NET applications. I was asked to replace MSDE with SQL Server 2000 and move every application from MSDE to SQL Server 2000 with minimum downtime.
Did any of you go through a similar process?
What is the best way of doing this conversion?
How to move the backups from MSDE to SQL Server?
Is it possible to have MSDE and SQL Server 2000 coexists for a time while moving stuff around and redirecting every connection?
Any hints or suggestions would be greatly appreciated.
Hi, I am developing an web-database application using ASP.net,c# and MSDE. and after the completion of the project i want to deploy the database over the server whichs got sql server professional edition. Are there any changes to be made while deploying it over the server and also will the connection string for MSDE and SQL client the same ? Please do clear me the confusions i have got .. thanks inadvance
Hi, I am a VB programmer and we have a VB application that uses Access as its db (~500MB mdb file) using DAO. We want to upgrade to MSDE/Sql Server because we have clients that will use around 5 connections to the db and others with no more then 20 users. I was asked to build a simple test program in Vb under MSDE that will enable us to test few clients working simultaneously (I have few days for that). There is so much material on MSDE and we just ordered an MSDE Developer guide book from the Amazon that will arrive in a few days. The amount of material is confusing like hell and I didn't work with ADO before, I don't even know if to work with Access 2000 or with a different db, can you advice ? Do you know of a good sample that show a beginner like me how to access MSDE from VB using ADO? If you do please please advice it will ease the pressure and the days are numbered. Thanks a lot.
I developed an app which stored data in SQL 2005, and encrypted some data using EncryptByPassPhrase( PassPhrase, TheData ), DecryptByPassPhrase( PassPhrase, TheData).
One of the implementations of this will have to store the data in SQL 2000, which doesn't support this functionality. Is there a simple data encryption functionality somewhere that I can implement within a stored proc so I can have my app be independent of the back-end data base server?, i.e. so I can have two different stored procedures depending on the back end db, and not to have the front end handle the encryption?
I have an application that is already installed on a Win2k3 Server using SQL Express 2005. I have another application that wants to use MSDE 2000 (already tried using SQL Express 2005, but it won't install). My question is, can both of these be installed on the same server and running at the same time without any problems? Thanks!
I have just started to create a new web project using the new VS 2005, but just discovered that my ISP has not yet converted to SQL Server 2005 and uses 2000 MSDE.
My first question is, assuming I don't use any new SQL Server 2005 features will there be any problems in using SQL 2000? Can I create/ reports and use the reporting services, or will I have to make 2 versions of my application?
2nd question is: I have to use their database name and userid. To me, this means changing every form that connects to SQL Server from my local information. Is there a way to make this dynamic so that I can change the DB name, userid, pw, etc. without creating 2 or more versions of this Web application?
With SQL 2000 and MSDE 2000, I only had to put a "." for the server name in a connection string. Now with SQL Express 2005 I have to acually reference the server instance name ".SQLEXPRESS".
Why is this?
Also, when running the command line tools for running scripts, I have to include the parameter "-S MACHINESQLEXPRESS" in the command line where as before I never used the -S parameter at all.
Anyone know why? I am curious because it is going to cause an impact on our upgrades for the client.
My only answer to these questions is that there is no SQL Agent running anymore.
Hello everyone,i want to know abt the "Difference between MSDE and SQL Server 2000". For example the features they support, capacity and requirements etc...
Can someone advise me if this is basically SQL server 2000 and will work effectively to simulate sql server on a stand alone development machine ? Is this what its meant for?
I have been using MSDE and I recently got Microsoft SQL ServerTM 2000 Developer Edition as part of my MAPS pack. Can and should I replace MSDE with Microsoft SQL Server 2000 Developer Edition on my development pc? Thanks in advance for any advice on pros and cons or known issues?
I recently upgraded my MSDE server to SQL Server 2000 database. After the upgrade, I see, every minute,in the logfile that the database is starting whilst in Enterprise manager the database is up and running. I would be grateful if you could bail me out of this anomaly.
I need to move the SQL Server 2000 Desktop Engine (MSDE) database and all jobs to the SQL Server 2005 Enterprise Edition. - May I detach and attach the DB in my case? - Where is the procedure to move the jobs from MSDE to SQL Server 2005?
