dbTalk Databases Forums  

Synchronize Database

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Synchronize Database in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mick Anderson
 
Posts: n/a

Default Synchronize Database - 12-19-2006 , 07:15 PM






Hi,

I have been working on automating Synchronizing AS Databases between
different instances of AS. The Synchronize seems to work well the only issue
I have is that the name of the database is reverted back to the database id,
which is different.

I checked out the XML elements of the Synchronize task and can't seem to
find an option to take the database name.

i.e.

Source Database:

<Database xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ID>pgc</ID>
<Name>Pathology Cost</Name>
<Description>pgc</Description>

After Sync, Destination becomes:

<Database xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<ID>pgc</ID>
<Name>Pathology Cost</Name>
<Description>pgc</Description>

Also checked out the AS backup and restore method. The database name reverts
to the database id here also.

Does anyone have advice or has anyone also hit this problem.

I guess I could script a rename of the AS database after the sync, hopefully
there is a better solution.

Thanks
Mick

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.