SQL Server...

[davedibiase]

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 ...

[westmich]

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.

Basically, it's a full-featured database server comparble to IBM DB2 or Oracle.

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.

[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

[Slade]

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.

M$ has an upsizing to SQL script/wizard

#1 Will it copy and make the database exactly the same *same fields, same records etc.*

For the most part, yes, but it will still require some grooming. The field types are different and have different properties.

#2 Is there a direct file that SQL saves the information under? Is it portable enough to bring accross servers?

Um, not exactly. Well, maybe yes, but I don't think you'd want to do it that way. For this, I'd recommend a book... There probably is a command similar to mysql's dump... but don't quote me.

Thanks

[big_al]

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

Hi,

#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

[goober]

Also, SQL doesnt' save things in a file such as access. it SERVES the data.

Just putting in a little detail.

[davedibiase]

thanks

[kevin_tremblay]

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.