(SB)… Its more feature-complete and has been stable for longer than the
Microsoft one. Its reported to be faster, too. According to their blurb, many
commercial MS JDBC drivers are essentially just repackaged versions of it! Its
almost a straight drop-in replacement; just be aware that the JDBC URL is
different, and autocommit defaults the opposite way round to the MS one! (At
least it used to - I always explicitly specify
so that may have changed unnoticed.)
jtds-1.2.2-dist.zip from the project web site. Extract to:
For the GlassFish,
For a sample connection string, see this jython script:
<groupId>net.sourceforge.jtds</groupId> <artifactId>jtds</artifactId> <version>1.2</version>
Microsoft SQL Server Management Studio¶
From the library, install
will be asked which features you want to install. Select Management Tools
before continuing with the installation:
To install client components including “Enterprise Manager”…
Get the SQL 2000 Enterprise Select CD.
In the set-up wizard select to install the server… on Windows XP you will only be able to install the client components.
In the Enterprise Manager, right click on SQL Server Group, select New SQL Server Registration, use the wizard, add the server… (probably more to do).
To restore the data, right click on the database, All Tasks, Restore:
To backup the data, right click on the database, All Tasks, Backup:
Make sure there is only one entry in the Destination, “Backup to:” list box.
It might be a good idea to Shrink the database before backing up. Definitely worth doing if you have lots of deleted records in your database.
For a simple way to backup a single table see Transact-SQL,