How does MSDE work? 1

[net123]

Experts:

I have MSDE on my PC at home installed via VS.NET. I also have SQL Server 2000 at work. How can I 'copy' the databases/tables at work so I can work on them at home and vice versa?

Any links to tutorials/books would greatly be appreciated.

 

[fluteplr]

The easiest way is to install the client tools from SQL 2000 on your home machine. You can use them to access MDSE.

Then just backup the database at work, move it to your home computer and restore it there.

Note if you copy the backup to a CD you will need to copy the file from the cd to your harddrive on your home box, in my experience SQL server will not restore directly from a CD.

 

[net123]

Sorry to be so ignorant, but how can I acquire the SQL Server 2000 client tools? What exactly entails these files? And what files do I need to backup?

The more explicitly you are, the more you can help me out.

Any good books/links on this?

 

[fluteplr]

You can install the client tools from the sql server 200 install disk. Sicne you have 2000 at work I am assuming you can put your hands on that. When you start the install it give you the option to instal sql server or the client tools only.

This will give you enterprise manager, query analyser, DTS (data transformation services) and a bunch of other sql related tools.

It will also install Books online (ofter refered to as BOL). Start by looking up backup and reading that.

You can also access BOL online, no pun intended at.

msdn.microsoft.com/sqlserver.

You need to backup and restore which ever databases you need to access at home.

 

[tlbroadbent]

I would be careful about installing the Client tools at home. Unless the home compuiter is only used for work purposes and is provided by your employer, you will probably violate the EULA by installing the client tools at home. Employer licenses don't automatically extend to employees' home computers.

You can create backups of databases at work and restore them to the MSDE instance at home without the GUI client tools. MSDE comes with the command line utility OSQL. OSQL can be used to execute T-SQL commands. It is simple to use and full documentation can be found in SQL BOL. Stands-alone SQL BOL can be downloaded from the Microsoft web site. See faq183-689 for download links.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm