CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.portal_starter_kit Tags:
Item Type: NewsGroup Date Entered: 9/25/2003 3:51:21 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 9 Views: 22 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
10 Items, 1 Pages 1 |< << Go >> >|
Johnny B
Asp.Net User
General portal database queries9/25/2003 3:51:21 PM

0/0

Hi

I am currently running the IbuySpy Portal on my lap top using MSDE. Could anyone clarify a few points for me ...

1) If I buy SQL Server 2000 which I aim to do ... will this simply install over my MSDE and leave my portal database intact and run it as per normal?

2) I currently use web matrix to explore my portal database - I notice that in the users table of the portal the field size property for the key UserID field is set to "4" - does this in fact mean that there is only capacity to have 9999 users and then no more can be added? I assume this is correct.

3) About sql scripts - is there some utility within SQL Server that you can point at a database and it will create a .sql install script that will recreate a database - is this what Query Analyser is capable of??

Any clarification welcomed

Regards

Johnnny B
wunderkinder
Asp.Net User
Re: General portal database queries9/25/2003 4:48:47 PM

0/0

I'll answer what I can:

#2: Regarding the field size, the int data type can hold 10 digits, and is stored in 4 bytes.

#3: In Enterprise Manager, you can right-click the database and choose All Tasks-->Generate SQL Script. This tool will create sql scripts for any objects you specify in the db, but it does ot copy the data. If you want an exact replica of an existing db, look at using Data Transformation Service (DTS), or you can detach the db, make a copy of the db files, then reattach the db files.
Jared Livingston
MrLivingston.com - Livingston Family Website

Test/Demo site - moonmark.com
Laura D
Asp.Net User
Re: General portal database queries9/25/2003 8:29:59 PM

0/0

Hi

I can see what you are getting at - I am aiming to get SQL Server next month - I think like me you are hoping that there is some Upsizing Wizard as when you upsize an Access database to SLQ .... I was assuming that there was a natural progression from MSDE to SQL ... and the database and the data would remain intact.

I can't really see the point of MSDE if this is not the case ...

Laura d
Benny.Tordrup
Asp.Net User
Re: General portal database queries9/26/2003 1:09:33 PM

0/0

Johnny,

SQL Server 2000 will not simply install over your MSDE. It will install another instance.

What you can do, is the following:

1) Stop your MSDE and make a copy of your portal database to a safe place.

2) Uninstall MSDE (this might include deleting leftover directories manually)

3) Install SQL Server 2000.

4) Locate the Data directory of the SQL Server 2000 instance (%Program Files%\Microsoft SQL Server\MSSQL\Data) and copy your portal database files into that directory

5) Attach the portal databases through Enterprise Manager

6) Create '<Machine Name>\ASPNET' as a login on the SQL Server (or 'NT AUTHORITY\NETWORK SERVICE' depending on operating system)

7) Possibly grant dbaccess to that login with regard to the portal database

8) Add that login as member of the role db_owner on the portal database.
Johnny B
Asp.Net User
Re: General portal database queries10/1/2003 1:19:04 PM

0/0

Hi

Thanks for that - I am getting conflicting information on this though - others tell me that you need to create your database from scratch again in SQL Server.

J
Benny.Tordrup
Asp.Net User
Re: General portal database queries10/2/2003 9:22:49 AM

0/0

Hi Johnny

Conflicting information about what? The move of physical database files? I've done it in several cases - I've even move a SQL Server 7 database to SQL Server 2000 without problems.

SQL Server 2000 and MSDE 2000 are with minor differences the exact same program. The files are exact the same - with regard to service pack level.

Benny
Johnny B
Asp.Net User
Re: General portal database queries10/3/2003 8:34:38 AM

0/0

Hi

In a book about Web Matrix I read that you cannot move the MSDE folder / files to SQL, that you have to recreate the database with an sql script with SQL .... as this was in a book I believed it - it gave the impression that MSDE was just for testing, and then you had to start again from scratch when you buy SQL.

Thanks for your comments - I guess I am going to have to ry this!

Regards

Johnny B
nemi
Asp.Net User
Re: General portal database queries10/3/2003 9:15:47 AM

0/0


Johnny B:

SQL Server 2000 will only install onto a Sever and not Desktop platform. What it will do is warn you of this when you try to install and will instead offer to install Enterprise Manager and Associated Tools only.

Once you have Enterprise Manager installed you can reattach your data easilly, and as far as I have experienced, with no data loss whatsoever.

Using Enterprise Manager you can export SQL scripts for any objects you may need them for, including the entire dataset if you so desire.

Nemi
You're fine! How am I?
Johnny B
Asp.Net User
Re: General portal database queries10/3/2003 9:57:02 AM

0/0

Hi

Thanks for that! I guess there is a developer edition of SQL Server that I cab use on my laptop??

Johnny B
nemi
Asp.Net User
Re: General portal database queries10/20/2003 7:04:51 AM

0/0

Johnny B:

You could look into SQL Server Personal Edition which is designed for desktop installs.

Nemi
You're fine! How am I?
10 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Vulnerability Assessment of Physical Protection Systems Authors: Mary Lynn Garcia, Pages: 382, Published: 2006
Professional BizTalk Server 2006 Authors: Darren Jefford, Kevin B. Smith, Ewan Fairweather, Pages: 696, Published: 2007
Designing Portals: Opportunities and Challenges Authors: Ali Jafari, Mark Sheehan, Pages: 302, Published: 2003
Web-powered Databases Authors: David Taniar, Johanna Wenny Rahayu, Pages: 340, Published: 2003
Database Systems for Advanced Applications: 13th International Conference, DASFAA 2008, New Delhi, India, March 19-21, 2008, Proceedings Authors: Jayant R. Haritsa, Kotagiri Ramamohanarao, Ramamohanarao Kotagiri, Vikram Pudi, Pages: 713, Published: 2008
Oracle Application Server 10g Web Development: Build and Deploy Web-Based Applications in the Oracle Environment Authors: Chris Ostrowski, Bradley D. Brown, Pages: 747, Published: 2004
Database Systems: A Practical Approach to Design, Implementation, and Management Authors: Thomas M. Connolly, Carolyn E. Begg, Pages: 1374, Published: 2005
Professional Portal Development with Open Source Tools: Java Portlet API, Lucene, James, Slide Authors: W. Clay Richardson, Donald Avondolio, Joe Vitale, Peter Len, Kevin T. Smith, Pages: 456, Published: 2004
Architectural Issues of Web-Enabled Electronic Business Authors: Nansi Shi, V. K. Murthy, Pages: 420, Published: 2003
Internet Riches: The Simple Money-Making Secrets of Online Millionaires Authors: Scott C. Fox, Pages: 293, Published: 2008

Web:
Augmenting multikey searching structure for general database queries Augmenting multikey searching structure for general database queries ... The ACM Portal is published by the Association for Computing Machinery. ...
Graphic Database Interface/Portal The data portion of the system is called the Graphic Database Interface (GDI). .... General users will only be able to execute queries using the portal ...
Applications of Quick-Combine for Ranked Query Models database query language SQL towards multimedia applications has been proposed. ... In general portals can be divided in two major groups. ...
Journal of Structural Biology : Web portal to an image database ... In data reports and data entry form pages, database queries and updates are accomplished by ... General considerations and architecture of the web portal ...
A crash course on database queries Of course, the specific nature of database queries (asopposed to general ..... The ACM Portal is published by the Association for Computing Machinery. ...
CodeProject: Useful SQL Queries to Analyze and Monitor SharePoint ... Microsoft SharePoint Portal Solution database is Microsoft’s proprietary database, ..... General, Are the queries portable to Sharepoint 3.0, member ...
Oracle Product Suites This “master-detail form” queries two tables from our Oracle 9i database. ... General steps to use Discoverer as a portlet in Portal. ...
An Ontology-Supported and Fully-Automatic Annotation Technology ... associated with general portals and develop a fully-automatic annotation ... the user query. Finally, Ontology Database provides the most fundamental ...
NISbase: Nonindigenous Species Database Network Documentation At the end of those meetings the general consensus is almost always the same; ... Once a query is submitted to the NISbase portal all selected database ...
ODBMS.ORG :: Object Database (ODBMS) | Object-Oriented Database ... OO database systems provide two general persistence techniques: explicit persistence ... Fetch an employee object from the database Query query = pmanager. ...

Videos:
Youtube Code of Conduct " UpDownMostly " Obaid Karki An Outcast Spinoziste Pantheon Hexalingual Automath Former UAE Under Secretary Independant Street-Knowledge Urban Talkshow Guru. Unaffili...
Youtube Code of Conduct " for Muslims and others of course " Obaid Karki An Outcast Spinoziste Pantheon Hexalingual Automath Former UAE Under Secretary Independant Street-Knowledge Urban Talkshow Guru. Unaffili...
Silicon Valley WebGuild: Vertical Search Trends Google Tech Talks August 23, 2006 Silicon Valley Web Guild http://www.webguild.org/ Presenters: Michael Yang, Founder, President and CEO, Become.co...




Search This Site:










vcard support

using ms office icons

no file available?

iistracer and webchecker

scheme for using relative font sizes in 3.x and 4.x

very urgent problem : all users have admin access on production portal !!!

tabs toolbar in dnn

child tabs/sub tabs.

seeking a skin expert

wysiwyg

i can't execute the codesmith files

3.0.12 system messages admin?

dnn2...super user details and pwd encryption string

mysql 5.0 is out, can we have dnn provider for it ?

discussion modules

gonna make me give up my css skins ??

i want common language specification document

skinning

dnn 4.0 user roles is currently unavailable

forum problems?

help! problem logging into dnn sites for any user

importing userdata to new database

3.0.6 issue - file manager - could not find a part of the path

footer display

general exception caused by search

document version control dor dnn 2

globals module usage

problems with templates

can this be localized

languages on freetextbox
  Privacy | Contact Us
All Times Are GMT