Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is a group? What is a SQL Server? And other ????
Message
General information
Forum:
Microsoft SQL Server
Category:
Installation
Miscellaneous
Thread ID:
00442091
Message ID:
00442124
Views:
9
>I've worked with Visual FoxPro and am just picking up SQL Server.
>
>When I install SQL Server 7 I end up with:
> - Microsoft SQL Servers
> - SQL Server Group
> - MDONALDNT (Windows NT)
> + Databases
> ...
>
>What is Microsoft SQL Servers? Is that the software?
>What is the group?
>Why would I want to create another group?
>Would all databases go in Databases or would I ever want to create another (Microsoft) SQL Servers?
>How do I set things up so I can transfer my work to my notebook?
>How is the transfer accomplished? What do I back up?

I am fairly new to SQL Server, so I will do my best to answer your questions:

You are in the Enterprise Manager, correct? With SQL Server 7, I believe you can manage multitple SQL Servers from one machine. With version 7, you can only have one SQL Server on a system, although I think this changes with SQL Server 2000.

Yes, all databases fall under the Databases node in the tree view. Every SQL Server can have multiple databases.

I am not sure about transfering a database or entire server from one machine to another, but I believe it is done with Data Transformation Services (DTS).

A great book I am reading to help me is Professional SQL Server 7.0 Programming by Robert Viera. Not geared for the VFP developer, but very good for a programmer.
Chris McCandless
Red Sky Software
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform