SitePoint Sponsor |
|
User Tag List
Results 1 to 8 of 8
Thread: SQL Server...
-
Nov 3, 2001, 18:21 #1
- Join Date
- Aug 2001
- Location
- Toronto, Canada
- Posts
- 829
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
SQL Server...
May someone please explain to me what I can do with SQL server...and some BASIC information about it...
*Is starting to learn MS SQL Server Develop Edition*
and needs to learn it FAST!
Maybe I can do it without a book but anywho some basic info to start off with would be amazing...
||Dave Di Biase||
----------------------------------
"There are 2 secrets in life. 1) Never say everything you know."
GFXWARS - The ultimate graphics battle!
-
Nov 3, 2001, 21:29 #2
- Join Date
- Mar 2000
- Location
- Muskegon, MI
- Posts
- 2,328
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Short answer from Microsoft:
Microsoft SQL Server is a relational database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. SQL Server 2000, the latest version, includes support for XML and HTTP, performance and availability features to partition load and ensure uptime and advanced management and tuning functionality to automate routine tasks and lower total cost of ownership.
There are several articles and numerous posts here at Site Point that touch on the subject. You might also want to try www.4guysfromrolla.com or www.sqlteam.com.
-
Nov 4, 2001, 08:59 #3
- Join Date
- Aug 2001
- Location
- Toronto, Canada
- Posts
- 829
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
ok...
Let me explain my prob...
I am currently using an MS Access database for some simple development while I finish the scripts. Now I wish to take the tables and design of the ms database and, I guess, importat it into SQL Server.
#1 Will it copy and make the database exactly the same *same fields, same records etc.*
#2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?
Thanks||Dave Di Biase||
----------------------------------
"There are 2 secrets in life. 1) Never say everything you know."
GFXWARS - The ultimate graphics battle!
-
Nov 4, 2001, 15:35 #4
- Join Date
- Aug 2001
- Location
- North Carolina
- Posts
- 153
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Re: ok...
Originally posted by davedibiase
Let me explain my prob...
I am currently using an MS Access database for some simple development while I finish the scripts. Now I wish to take the tables and design of the ms database and, I guess, importat it into SQL Server.
#1 Will it copy and make the database exactly the same *same fields, same records etc.*
#2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?
Thanks
-
Nov 4, 2001, 16:24 #5
- Join Date
- May 2000
- Location
- Victoria, Australia
- Posts
- 1,661
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Re: ok...
Originally posted by davedibiase
Let me explain my prob...
I am currently using an MS Access database for some simple development while I finish the scripts. Now I wish to take the tables and design of the ms database and, I guess, importat it into SQL Server.
#1 Will it copy and make the database exactly the same *same fields, same records etc.*
#2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?
Thanks
#1 SQL Server 2000 has a pretty sweet import feature (as does 7), you will however have to change some data types to suit your needs.
#2. Yes it does, You cannot use this file as a stand alone file but you can unattach the MDB File and log file to take then accross to another server.
I would suggest you get a book, there are so many things SQL Server can do and make your life soooo much easier, like Stored Procedures, Triggers, index's, replication etc.
Hope this helps.NET Code Monkey
-
Nov 4, 2001, 21:42 #6
-
Nov 5, 2001, 17:37 #7
- Join Date
- Aug 2001
- Location
- Toronto, Canada
- Posts
- 829
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
...
thanks
||Dave Di Biase||
----------------------------------
"There are 2 secrets in life. 1) Never say everything you know."
GFXWARS - The ultimate graphics battle!
-
Nov 6, 2001, 08:05 #8
- Join Date
- Jul 2001
- Location
- Boston Area (North shore)
- Posts
- 233
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
SQL servers import feature works great, I move stuff from Access to SQL all the time.
Yes the data is stored in a folder called data under the SQL folder unless you located the data files to some other location other than the default.Kevin Tremblay-- Sys Admin
work: kevin_tremblay@hsgmed.com
"The object of the journey is not to arrive."
Bookmarks