CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.classifieds_starter_kit Tags:
Item Type: NewsGroup Date Entered: 5/5/2006 8:10:29 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 4 Views: 14 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
5 Items, 1 Pages 1 |< << Go >> >|
HarrX
Asp.Net User
SQL Scripts5/5/2006 8:10:29 AM

0/0

I need to port the DB to SQL Server 2000,

I can see SQL scripts to create tables but how can I create all the stored procedures?

Maybe another question should be How should I port the DB to SQL 200 server? :)

 

Thanks

paggy4u
Asp.Net User
Re: SQL Scripts5/5/2006 10:48:56 AM

0/0

For creating stored procedures for aspnetdb, you need to run aspnet regsql  from your local machine to sql database.

Pl. refer to blogs of mr. scott guthrie to learn how to run aspnet regsql.

for creating database and stored procedures you need to run sql from query analayser to your local sql.
this will create database and storeprocedures as well.

First run the query analyser and then create store procedures from aspnetdb.

Hope this helps

Paggy4u


Paggy4u
-----------------------------------------
An Unblinking eye on IronRuby,Asp.Net and .Net
http://ironruby.blogspot.com/
an an
Asp.Net User
Re: SQL Scripts5/7/2006 3:37:49 PM

0/0

hi Paggy4u :

could u provide the link for this.

i searched scottgu's blog , but can't find the related topic

aspnetdb procedure site:http://weblogs.asp.net/scottgu

 

thx

justin0501
Asp.Net User
Re: SQL Scripts5/7/2006 8:59:21 PM

0/0

you can find that utility in the following folder:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

it creates the asp net membership tables and stored procs for you. Obviously, you will need access to the server you want to run it on.

paggy4u
Asp.Net User
Re: SQL Scripts5/8/2006 4:34:05 AM

0/0

an an:

hi Paggy4u :

could u provide the link for this.

i searched scottgu's blog , but can't find the related topic

aspnetdb procedure site:http://weblogs.asp.net/scottgu

 


-----------------------------------------------------------------------------------
Hi an an,

Here is the klink for you for Mr.ScottGu's Blog with the article you need.

Click Here

Thanks

Paggy4u


Paggy4u
-----------------------------------------
An Unblinking eye on IronRuby,Asp.Net and .Net
http://ironruby.blogspot.com/
5 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
PHP 5/MySQL Programming for the Absolute Beginner: No Experience Required Authors: Andy Harris, Pages: 464, Published: 2004
Oracle SQL*Plus: The Definitive Guide Authors: Jonathan Gennick, Pages: 502, Published: 1999
SQL Server 2005 Bible Authors: Paul Nielsen, Pages: 1293, Published: 2006
Professional ASP.NET 2.0 Authors: Bill Evjen, Scott Hanselman, Farhan Muhammad, Srinivasa Sivakumar, Devin Rader, Pages: 1253, Published: 2005
Oracle Database 10g PL/SQL 101: Learn to Write Powerful PL/SQL Programs Authors: Christopher Allen, Pages: 416, Published: 2004
Oracle Application Server 10g Administration Handbook: Administration Handbook Authors: John Garmany, Donald K. Burleson, Pages: 408, Published: 2004
Beginning SQL Server 2005 Programming Authors: Robert Vieira, Pages: 688, Published: 2006
Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts Authors: Harry Conway, Michael R. Ault, Mike Ault, Donald Burleson, Pages: 1200, Published: 2006
Portable DBA: SQL Server Authors: Damir Bersinic, Stephen Giles, Pages: 352, Published: 2004

Web:
SQL Server Central: Scripts SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server. Update to Simon Facer's script. Read more. ...
SQL Scripts & Samples This script will check the rerun status of failed or cancelled jobs and the job steps. PL/SQL String Parser 8/25 PL/SQL String Parser can parse sentences ...
SQL Server development techniques and sql scripts. Author Nigel Rivett SQL Server development techniques and sql scripts - Author Nigel Rivett.
Database Administration and SQL scripts Database administration and SQL scripts. Database design using Informix and Oracle. Database administrator, software engineering and software articles.
T-SQL Scripts Some useful Microsoft SQL Server Transact-SQL scripts. MSSQLCity.Com - all about MS SQL (SQL Server Articles, FAQ, Scripts, Tips and Test Exams).
Four Hundred Guru--V6R1 Enhancements for Run SQL Scripts Among the many enhancements that V6R1 provided for System i and i5/OS are several for Run SQL Scripts, which improve its function and broaden its usability. ...
Database Administrator SQL scripts Database administrator SQL scripts. Database design using Informix and Oracle. Database management, software engineering and software articles.
SQL Scripts SCRIPTS.MTRS]GEN_DEL_MTR_DATA.SQL;4 Rem Filename : gen_del_mts_id_data.sql spool del_mts_id_data.sql set echo off; rem column min_date format a20 heading ...
Using ij to run SQL scripts ij scripts, files that end in an .sql extension and contain SQL commands, can be run using the Derby plug-ins. This allows you to use SQL scripts containing ...
SQL Script Builder - Multiple Platform Database Migration Tool SQL Script Builder is software that create a database migration sql script (or dump file) from any ODBC data source. The script produced will migrate all or ...

Videos:
SQL Server 2008 T-SQL Debugger The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functi...
Data Modeling for the Database Developer, Designer & Admin. DBAs, developers and designers are often tasked with building and managing databases. Especially when the database has been developed by someone else...
067-Oracle DBA Fundamentals Hands-On #01-The most important Dictionary (Oracle) As a DBA, you are responsible for obtaining the most important dictionary views and report them to the senior DBA of your organization. You need to k...
004-How to create a schema to practice iSelfSchooling's hands-on Oracle Training It describes how to create a schema to practice the iSelfSchooling's hands-on. You can download the create_tables.sql script from http://www.iselfsch...
MS SQL Server 2008 - SSIS - Script Component Changes This demo is all about changes done to script component in SSIS in SQL Server 2008.
Moodle Grade Exceptions Interface: Groups and Individuals! Moodle Grade Exceptions Group by Grade Suggestion Consider Downloading this Video The size of the fonts in many applications makes it difficult to re...
How to deploy custom scripts with Quest's Change Director Watch this video to learn how to deploy custom scripts with Quest's Change Director for SQL Server
Mark's Delicious Library To SQL Export Script Uses Delicious Library, Ruby (Core, REXML, ActiveRecord), Cocoa, and mySQL. CocoaMySQL is used to check the mySQL records in this screencast. mark [a...
SQL Server 2005 Part 6.3 Generating Scripts
SQL - Learning SQL Server 2000 System Administration Level 4 The SQL - Learning SQL Server 2000 System Administration Level 4 is part of KeyStone Learning Systems library of more than 1,200 CD-ROM and video-bas...




Search This Site:










msbuild documentation

authentication timeout doesn't work. coockie expires always in one minute. help!

how often is profile data loaded?

call method of master page from update panel

visual studio 2005 request / option available

treeview hover text

solpartmenu child menu css class

user account filter?

deploying asp.net 2.0 website with login controls

memberships & databases

excpetional themes

2.1.2 aspnet problems on win2k

custom nested collections in properties window

multiple questions...

conent page scroll bar

problem while loading website

virtual directory under dnn site

web app response faster when ssl enabled!!!! why?????

new in vs 2005 web developer

forms authentication timeout

confused on images not showing on master page

skins and containers

creating custom fields for the createuserwizard and storing them into the membership db

internet explorer blocking cookies from iframe

media library starter kit

cannot get azman roles to work at all.

solpartmenu invisible in ie5

menu buttons on a master page...

getordinals question

authorization using sql database

 
All Times Are GMT