data synchronization

Dear All,
I have 3 databases in sql , one db have a master data and I want to
synchronize to other 2 databases. is any sync. sw is available for that. or
is any thing in SQL also. databases may be in same place or remortly also
please help
thanking you
Regards
K R LalYou could write a script to keep the databases updated and run the script at
specific intervals. You may also consider replication. Take a look at
Replication in Books Online.
"Lal" <kr.lal@.luxoroffice.com> wrote in message
news:O8kSCgaCFHA.904@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have 3 databases in sql , one db have a master data and I want to
> synchronize to other 2 databases. is any sync. sw is available for that.
> or
> is any thing in SQL also. databases may be in same place or remortly also
> please help
> thanking you
> Regards
>
> K R Lal
>|||Lal
The question is how often do you want to get a fresh data from the master?
Replication, especially transaction replication could suite you.
Also . I'd look at BACKUP/RESTORE commands altogether with BACKUP LOG file
as well.
"Lal" <kr.lal@.luxoroffice.com> wrote in message
news:O8kSCgaCFHA.904@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have 3 databases in sql , one db have a master data and I want to
> synchronize to other 2 databases. is any sync. sw is available for that.
or
> is any thing in SQL also. databases may be in same place or remortly also
> please help
> thanking you
> Regards
>
> K R Lal
>|||Hello Lal.
Replication would be the defacto response although it may not suit your
environment or needs. You could also check out DB Ghost which can synchroniz
e
both data or schema or both which can be scheduled to run when you like. I
created a SQL Server job to synchronize my database with the hosting company
so I could have a reporting and disaster recovery database in case anything
went wrong with my hosting company. You can download the example here:
http://www.innovartis.co.uk/downloa...J
ob.zip
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"Lal" wrote:

> Dear All,
> I have 3 databases in sql , one db have a master data and I want to
> synchronize to other 2 databases. is any sync. sw is available for that. o
r
> is any thing in SQL also. databases may be in same place or remortly also
> please help
> thanking you
> Regards
>
> K R Lal
>
>sql

Data Space Problem

Hello:
I have several SQL 2000 databases that displays 0 space
available when I view the properties of the database.
However when I change to the taskpad view, the view
indicates that there is space available.
Is this some kind of bug in SQL Server? Is there any fix
for it?
Any help would be appreciated?
Brennanrun DBCC UPDATEUSAGE and see if that helps.
--
Andrew J. Kelly SQL MVP
"Brennan" <anonymous@.discussions.microsoft.com> wrote in message
news:59ea01c40090$b4eedc60$a401280a@.phx.gbl...
> Hello:
> I have several SQL 2000 databases that displays 0 space
> available when I view the properties of the database.
> However when I change to the taskpad view, the view
> indicates that there is space available.
> Is this some kind of bug in SQL Server? Is there any fix
> for it?
> Any help would be appreciated?
> Brennan|||Thanks
That worked
Brennan
>--Original Message--
>run DBCC UPDATEUSAGE and see if that helps.
>--
>Andrew J. Kelly SQL MVP
>
>"Brennan" <anonymous@.discussions.microsoft.com> wrote in
message
>news:59ea01c40090$b4eedc60$a401280a@.phx.gbl...
>> Hello:
>> I have several SQL 2000 databases that displays 0 space
>> available when I view the properties of the database.
>> However when I change to the taskpad view, the view
>> indicates that there is space available.
>> Is this some kind of bug in SQL Server? Is there any
fix
>> for it?
>> Any help would be appreciated?
>> Brennan
>
>.
>

Data Mining

Are the Data Mining capabilities in Excel only available with Excel 2007?

How does one implement the data mining in Excel 2007?

The recently published Data Mining add-ins for Office only work with Office 2007.

> How does one implement the data mining in Excel 2007?
I am not sure I understand the question. Are you interested in implementing your own add-ins for Excel? Or in using the existing add-ins?

|||

The SQL Server Data Mining Add-Ins for Office 2007 work only with Office 2007 - notably Excel 2007 and Visio 2007.

To implement an Excel 2007 Data Mining solution, you first need Excel 2007 and SQL Server 2005 Analysis Services. Analysis Services is included with SQL Server 2005 Standard and Enterprise Editions and is an installation option. Finally you need the add-ins package itself, which is available as a free download from here: http://www.microsoft.com/sql/technologies/dm/addins.mspx

If you currently do not have licenses for Office 2007 and/or SQL Server 2005, this link (http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/4429.aspx) provides a guide on how to try out the data mining addins using evaluation editions of Office 2007 and SQL Server 2005.

Data Mining

Are the Data Mining capabilities in Excel only available with Excel 2007?

How does one implement the data mining in Excel 2007?

The recently published Data Mining add-ins for Office only work with Office 2007.

> How does one implement the data mining in Excel 2007?
I am not sure I understand the question. Are you interested in implementing your own add-ins for Excel? Or in using the existing add-ins?

|||

The SQL Server Data Mining Add-Ins for Office 2007 work only with Office 2007 - notably Excel 2007 and Visio 2007.

To implement an Excel 2007 Data Mining solution, you first need Excel 2007 and SQL Server 2005 Analysis Services. Analysis Services is included with SQL Server 2005 Standard and Enterprise Editions and is an installation option. Finally you need the add-ins package itself, which is available as a free download from here: http://www.microsoft.com/sql/technologies/dm/addins.mspx

If you currently do not have licenses for Office 2007 and/or SQL Server 2005, this link (http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/4429.aspx) provides a guide on how to try out the data mining addins using evaluation editions of Office 2007 and SQL Server 2005.

Data in sysobject table

I understand that there are separate installables available for different languages (chinese, french etc.) in sql server. The question is, if I install sql server in say, chinese, does it mean that the schema catalog information stored in system tables (say sysobjects) will also be in chinese ? or the data rows in sysobjects is only in english.

Thanks for any helpEvery case I've ever seen has the system tables and columns named in English, although I've heard of a few (say maybe 3 out of several hundred thousand, over more than ten years) cases where the columns were named in the native language. All of those cases were more or less unbridled disasters, which I think were self-inflicted injuries (where someone had gone places and done things that they shouldn't).

-PatP