saving the database

hi,

I am using SQLSERVER 2000. I had installed a trial version from microsoft. Now, it is about to expire. But i am not done yet with my project. So, I want to reinstall the trial version. But i don't know how can i save my current database, and transfer it to new database, that i will install.

Kindly, explain it in detail, as I am new to database stuff.

ThanksI am not sure if ms will allow you to uninstall/install the trial edition ... Anyway, you can detach and copy the database (then reattach when sql server is reinstalled) or backup/restore.

In Enterprise manager, right-click on the database -> All Tasks - In all tasks you will see Backup Database and Detach Database. For backup, follow the wizard, and back the db up to the hard disk. Later, right-click again and restore. For detach, once you have detached then copy the db to another name or directory. Then click on Databases and attach the database.

Saving original SQL Database and My.Settings when reinstalling or updating

Hello all...

I am working on a project that contains several databases in SQL and many settings. The problem I am encountering is that I want to be able to update the program for all my customers. That is no problem.

The problem I am meeting is where, when the program is updated, all the settings and all the information in the databases reverts to the default values, or the values that were compiled with the new update.

I want to be able to update their program without deleting all the settings they have.

Thanks,

Andreas Renberg

hi Andreas,

IQ Andreas wrote:

Hello all...

I am working on a project that contains several databases in SQL and many settings. The problem I am encountering is that I want to be able to update the program for all my customers. That is no problem.

The problem I am meeting is where, when the program is updated, all the settings and all the information in the databases reverts to the default values, or the values that were compiled with the new update.

I want to be able to update their program without deleting all the settings they have.

Thanks,

Andreas Renberg

as regard "settings", I'm calling me out as I do not usually store important settings but connection information such as server name and the like in a kinda of setting file...

as regard the database, you have to modify the way you provide your database to the end user as, obviously, overwriting his/her database with your in order to update metadata (adding tables, modifying procedures and the like) will make all his/her data vainishing..

so you usually should go for alternative solutions in order to deploy database metaschema updates.. have a look at http://msdn.microsoft.com/msdnmag/issues/04/09/customdatabaseinstaller/, a nice article about that, where the presented solution is simple and efficient... more, it let you manage the relative DDL code under source code control systems like Visual Source Safe..

regards

Saving a Web Report to Visual Studio

First let me start by Saying I am very new to 2005 Reporting Services.
I deployed a report server project created in Visual Studio to another
server. The drive that original file was on crashed, and the backup
turned out to be useless.
Is there a way I can take the deployed XML / rdl report, and save it to
a new location. Thus allowing me to save my backside and continue work
on the report from Visual Studio Report Designer.
Signed,
Hoping for a Christmas MiracleGo to report manager, click on the report, click on the properties tab.
Click on Edit lin under Report Definition. Save locally on your hard drive.
In your project you add an existing item and select the rdl from wherever
you saved it. It will be copied over into your project with the rest of the
rdl files you have.
Not real discoverable.
The RDL is not stored on the server as a file. This procedure allows you to
get the rdl from the RS database.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<Greg.Crossan@.gmail.com> wrote in message
news:1165950537.624411.181850@.l12g2000cwl.googlegroups.com...
> First let me start by Saying I am very new to 2005 Reporting Services.
>
> I deployed a report server project created in Visual Studio to another
> server. The drive that original file was on crashed, and the backup
> turned out to be useless.
> Is there a way I can take the deployed XML / rdl report, and save it to
> a new location. Thus allowing me to save my backside and continue work
> on the report from Visual Studio Report Designer.
> Signed,
> Hoping for a Christmas Miracle
>

Sample databases for data mining

Hello

I'm looking for sample database for data mining in SQL Server 2005. In my project I need to use all algorithms provided by SQL Server 2005. I know that we have "SQL Server 2005 Samples and Sample Databases" on microsoft.com site, but there are only AdventureWorks data sets. I need sth less popular, but similar.

I have found http://www.kdnuggets.com/datasets/index.html and others, but I don't see data sets good for multidimensional analysis.

The origin of data may be natural or artificial, it doesn't matter.
I don't have to generate my own data, because I had to discover new knowledge, that will be surprising to me.

Any help would be appreciated.
Thanks in advance.

(sorry for my English)

There are public datasets available on many sites including the UN- they may be interesting.

http://unstats.un.org/unsd/demographic/products/socind/default.htm

And there are still samples available for SQL Server 2000 which may also be useful. You need to know how to install them for 2005. There are some notes on that here.

Sample databases for data mining

Hello

I'm looking for sample database for data mining in SQL Server 2005. In my project I need to use all algorithms provided by SQL Server 2005. I know that we have "SQL Server 2005 Samples and Sample Databases" on microsoft.com site, but there are only AdventureWorks data sets. I need sth less popular, but similar.

I have found http://www.kdnuggets.com/datasets/index.html and others, but I don't see data sets good for multidimensional analysis.

The origin of data may be natural or artificial, it doesn't matter.
I don't have to generate my own data, because I had to discover new knowledge, that will be surprising to me.

Any help would be appreciated.
Thanks in advance.

(sorry for my English)

There are public datasets available on many sites including the UN- they may be interesting.

http://unstats.un.org/unsd/demographic/products/socind/default.htm

And there are still samples available for SQL Server 2000 which may also be useful. You need to know how to install them for 2005. There are some notes on that here.