20,000 Ft. Directional Question About Technologies And Capabilities
Nov 20, 2006
Greetings,
My desire is to have my primary db in FL and an online hot standby in both my MI and CA offices. The hardware is in place, as well as T1 size pipes. The solution I'm looking for would have all databases online in case of hardware / environmental failure although the application would only be pointing at the primary (or designated) database server. We have another 3rd party solution available, but I'd like to stay native SQL if possible.
Is replication the way to go?
Does one-to-many work?
Can all the db's be online and available while replicating?
Can I catch up if switched to one of the other db's temporarily?
note:This is 100% SQL 2005.
Thanks -- sorry for the newbie-flavor of the question, but I'm sure a gazillion people have already been down this decision branch.
Dan Ribar
View 5 Replies
ADVERTISEMENT
Jan 31, 2005
Hi all,
I'm about to embark on a new project and I'm having a few troubles deciding what .NET technologies I need to learn and employ.
The system will be built around SQL Server.
It will involve a client application that will be used to gather data offline using MSDE, then sync back up with the online DB. This will then have a web front-end for users not employing the client app.
I'm pretty fine with the whole front-end and data manipulation thing, but I don't know where to start with the synchronisation.
Could someone please tell me how I should go about getting the systems to communicate? Do I need to use Web Services and do it by XML? Message Queueing? Or are there simpler ways?
Thanks!
View 2 Replies
View Related
Nov 22, 2007
Hi,
I tried to install sharepoint server 2007 as a standalone in my computer. When i run the sharepoint products and technologies configuration wizard, i get the following error,
Failed to create sample data.
An exception of type System.Data.Sqlclient.SqlException was thrown. Additional Exception information:
Cannot open database "SharedServices2_DB_28aa01d8************************" requested by the login. The login failed.
Login failed for user "domainAdministrator"
Please advice me to solve this issue.
Thanks,
Magesh S
View 18 Replies
View Related
Mar 27, 2007
I am starting on a project where we will be using SSIS. I am totally new to it and would like to ask for your input on whether SSIS can do what I want it to do.
What we are wanting to do is to take data that is loaded into a queue table, and then possibly transform it a bit and load it into a common db as a batch. After that, subsets of that data should then be replicated to other databases based on some criteria. So what we end up with is one database with all the data and two (for now) databases, each with a subset of that data.
Ideally we would want our backend apps to work with the data in the common database and our frontend apps to work with the data in the two other databases.
So I have a couple of questions.
Can SSIS do two-way replication? So if the frontend changed one of the subset databases, could it replicate the change to the common database? And likewise, if the backend changed the common database, could it replicate the change to one of the subset databases?
What is a good way to execute a package from code? For example, from code we would load some tables, and then we would like to execute the SSIS package after that to go through the tables and transform and send that to other tables in one big batch job.
Is it possible to look at the status of package execution from another computer other than the one running the package? I know one way is just for the package to write to a table what it is doing and that table can then be looked at. I was wondering if there was some more elegant way of doing this.
We are also looking at whether we can do our archiving process from SSIS. All it involves is taking the data in the common database and transforming it to xml and outputting it as a file. Is there a way to write out to an xml file? I saw that you can read in xml in SSIS, but I didn't see a way to output xml.
Those are all my questions for now. If you can help me out with even one of them, it would be much appreciated.
Thanks,
Raphael
View 4 Replies
View Related
Jun 20, 2000
What are my limitations with search? Can I search on a phrase? If I search for "bookshelf" will I get everything with 'book' and 'shelf'? Can I search using "and"? Can I sort the results like yahoo does? Can I rank the results? For example, if I search for a product can I sort the results by price?
View 1 Replies
View Related
Jul 20, 2005
I'm composing a comparison table of database capabilities of severaldifferent products. I've read the Transact-SQL reference and havegathered most of the information needed for SQL Server 2000 (MSSQL),but there are some things that I'm not very sure of. Could someoneconfirm or complete the points below?* MSSQL can index binary data but only for BINARY & VARBINARY fieldsand not IMAGE.* ALTER TABLE can't rename column name/index name/constraint name.* A functional index (index on expression/function) can be definedusing user-defined function, e.g. CREATE INDEX idx ON t (MY_FUNC(f))* Maximum number of indexes per table?* SEQUENCE (as in PostgreSQL) is not supported, but there is a datatype called TIMESTAMP/ROWVERSION that is 64-bit. SEQUENCE can also beimplemented using a 'counter table'.* Regexp is not recognized, only standard SQL LIKE pattern.* Maximum number of schemas per database?* There is no BOOLEAN data type, but one can use BIT as analternative.* Does MSSQL use a generational/MVCC/record-versioning architecture,to allow writers to not block readers and vice versa?* Can several user-defined functions be created with the same name butwith different signatures (argument type)? For example, REVERSE(text)and REVERSE(varbinary).* Does MSSQL have/use WAL (write-ahead logs)?* Can a unique index contain multiple NULLs?
View 2 Replies
View Related
Jan 22, 2007
Hello all,
I have a winform application, where in we get the parameters from the reporting service and we display them in a panel for user's to input their criteria. So far everything worked good, but now we have a requirement wherein dynamic functionality is needed.
For Example:
Based on a selection of a combobox value, we want the other control to be enabled or disabled. Also we want default value of a control to be calculated based on another control's value like .. if user enters value "1" in textbox1 then texbox 2 should have default value of "6". (Textbox1 + 5).........and mix and match of such capabilities.
The Question is........IS IT POSSIBLE??? and if yes...HOW!!!
View 6 Replies
View Related
Nov 10, 2006
Hi!
I've read a lot of informoation about the Microsoft Sequence
Clustering algorithm, but the more i read more confused i get. Here's
my doubt:
Can it discover sequences of "tokes" and then group them? Or only compare sequences in order to group them?
Thanks in advance
View 3 Replies
View Related
Jan 22, 2008
I've been given a brief to create a web based MI solution to enable users to gain information about their departments and drill down and analyse information presented to them.
I've been asked to look at Reporting services for this, we have been using Crystal Reports, but not to the extent of public facing MI delivery that this project demands.
Could I ask the forum some basic Questions?
1> Is it possible to produce live interactive reports for use on the internet with reporting services.
2> Can I produce reports that can drill down on data, and that can be tweaked so that they are extremly 'user freindly?
3> What are the chart options available, I have been asked to look into providing 'stickmen graphs'. In that a chart is produced to represent a population, and each item of the population is represented by a little man graphic.
4> Are there any good websites that have code snippets and the like to SSRS?
5> Can you recommend any good books.
Thanks in advance for any reponses to these queries.
View 2 Replies
View Related
Nov 18, 1999
SQL Version 7.0
I have set up bi-directional replication between two databases on one table that has the structure of
Table Name : tblTrade
id : int (identity)
TicketNo : int (globally assigned via a sp - therefore always unique)
Location : int (On Server 1 defaults to 1) ---|PRIMARY
(On Server 2 defaults to 2) ---|KEY
.General Trade Fields...
Hence when a trade is entered into Server1 the Location defaults to 1 and is then replicated via an horizontal partition filter on the Location field. And similar for Server2.
Now Inserts work fine. However when a the following operations occur
DELETE - A DELETE against a record on Server1 results in ALL records being deleted from Server2
UPDATE - An UPDATE operation against a record on Server1 then ALL records get updated with the UPDATE SET clause.
The same happens with Updates on Server2 replicated to Server1.
Now it looks like the WHERE clause is missing from the replicated statements.
WHAT IS GOING ON, AND DOES ANYONE HAVE AN IDEA OF HOW TO GET AROUND THIS OR SET UP REPLICATION TO WORK PROPERLY
Regards
Steve
View 1 Replies
View Related
Mar 20, 2008
From a service broker newbie...
Most of the examples I've found and played with demonstrate two way conversation. A sender initiates a call, and gets a message back.
My Requirements doesn't really need two way communication. I have a scenario where triggers on two different tables result in modifications to a third table, and I don't want the triggers to deadlock each other, so an asynchronous queueing mechanism seems like the perfect solution...
But I can't seem to make it work one way.
I can get one message through, and then all subsequent messages hang up in the transmission queue with the very informative "One or more messages could not be delivered to the local service targeted by this dialog."
I'm thinking all the examples work the way they do because you have to notify the transmitter that the message was
received by sending a message back... and by not doing this I'm stuck in the first conversation. I was thinking that by doing END CONVERSATION <Msg Handle> in the stored procedure bound to the receiver's queue was doing that.
Do I have to communicate bi-directionally always? I guess this is a safety feature but I trust MSMQ to deliver messages...
Thx
View 3 Replies
View Related
Sep 27, 1999
The docs state that a timestamp column is required for bi-directional
replication. I am not syncing the databases since they are too big and
it is a new project so I can guarantee at start that there will be two
exact copies of data. The data is being converted from a FoxPro db to
sqlserver.
The question is:
How do you design the timestamp columns for partioned bi-directional
replication? Does the publisher get the timestamp and the subscriber get
a binary(8)? Since there are two publishers is a distinct timestamp and
binary pair required for each server? See below...
Server: REP1 REP2
Table: tblTest tblTest
Columns: col1... col1...
tsREP1 timestamp tsREP1 binary(8)
tsREP2 binary(8) tsREP2 timestamp
Do the binary(8) columns need to be removed from the articles? Can
anyone explain how the timestamp is used to stop loop back? Is the loop
back check done on the Publisher or Subscriber?
Thanks,
Norman
View 1 Replies
View Related
Jan 14, 2000
Server_1 contains DB_A and DB_B. Server_2 contains DB_A and DB_B.
Can replication be setup where Server_1 DB_A (publisher) publishes to Server_2
DB_A (subscriber) and Server_2 DB_B (publisher) publishes to Server_1 DB_B (subscriber)? The environment is NT 4 (sp3) and SQL 6.5 (sp5a). Thanks in advance.
View 1 Replies
View Related
Nov 12, 1999
Hi All
I am trying to set up bi-directional replication (between two domains) on a simple test table prior to installing it on my Live system. The table structure is along the lines of
id int (Primary Key)
name varchar(50)
location int
I use the Location field and the filter for the Publication. i.e. 1 = Server1 and 2 = Server2
Well I set the replication up on Server1 to Server2 and test the subscription and everything replicates perfectly. Note : When I set the Server2 subscription to Server1 I recreate the structure of the table on Server2
After performing a few replicated INSERTS into the table on Server1 and they have replicated through to Server2. I set Pub/Sub on Server2 to Server1. NOTE : on the setup of the subscription I select the option that the schema and data on the target table is correct.
As soon as I enter a line into the table on Server2 the replication monitor errors on Server2 with the message that the insert stored procedure for the replication cannot be found, indicating that they have not been created.
WHAT AM I DOING WRONG FOR THE SET UP OF BI-DIRECTIONAL REPLICATION??????
Thanks
Steve
View 2 Replies
View Related
Feb 28, 2006
Besides loopback detection, is there anything else that is needed to prevent the replication command from sending back to the source. Cos i am having problem with the subscriber B sending back the replication to A in the form of B as the publisher and A as the subscriber.
:confused:
View 3 Replies
View Related
Aug 25, 2005
Two Servers,1st 2nddatabase a -------> after replication a'b' <------- after replication bon 1st server a is replicated to 2ndon 2nd server b is replicated to 1stI tried with merge replication it is working fine.But if i tried to usetransactional replication it give some error like "accessviolation".Using tansactional replication is it possible.plz help me toslove this problem.Regards,Senthil prabu R
View 1 Replies
View Related
Oct 24, 2007
Following setup s1<--- p1<-->p2 ---->s2 (bidirectional replication between publishers as each one have its own subscriber)
What are the disadvantages of this solution if only one publisher gets written to at the time.
How about schema changes (would I need to stop all activity on p1 & p2 similar to p2p replication) ?
Would changes get republished to s1 & s2 ?
Are identities the only problem when instead on p1 as main server I start using p2 ?
Thank you.
View 4 Replies
View Related
Oct 19, 2004
Hi,
I am trying to setup bi-directional transactional replication between 2 SQL Servers,
I add the subscription on both the servers using the code below.
EXEC sp_addsubscription @publication = N'test',
@article = N'all', @subscriber = 'AnyServer',
@destination_db = N'test', @sync_type = N'none',
@status = N'active', @update_mode = N'read only',
@loopback_detection = 'true'
GO
I have defined 'AnyServer' on both the servers using cliconfg
(Server1's AnyServer pointed towards Server2 and Server2's AnyServer pointed towards Server1, I need to do that because there is a restriction to run the same code on both the servers),
After inserting a record on server1 in the 'test' database, the changes successfully transfers to the server2, then server2 sends it back to server1 and server1 generates the error of
"Violation of PRIMARY KEY constraint 'PK_Table1'. Cannot insert duplicate key in object 'Table1'."
It seems as if loop detection is failing if I keep the same subscriber name on both sides.
It runs fine when I change the subscriber name in the subscription (@subscriber = 'Server2' for server1 and @subscriber = 'Server1' for server2).
Can anybody explains this behavior to me?
View 2 Replies
View Related
Jul 23, 2005
Hi,Our company is an independent Voice applications solution provider withnumber clients using our suite. We have a CT application suite which isrunning with Application Server and SQL Server 7 / 2000 as DB Enginesat the back end.The SQL server has two databases configured:Logging Database - Massive updates every second, the data growsrapidly,Configuration Database - Generally small-sized and updatedoccasionally.Now we want to have the reslience implemented on the server. We have tosynchronize the two databases 'real-timely' and in 'efficient'manner, so that if Primary server or its Databases gets unavailable,the users are seamlessly switched over to the Secondry server that willhave its own set of data updated and well synchronized.Typically, it can be explained as follows:1. We will have 2 database servers A - Primary (acting as publisher)and B - Secondary (acting as subscriber). Our application will beinitially connected to A.2. When A becomes unavailable (for whatever reason), the applicationwill fail-over to B.3. All the users will be switched to server B and the updates are beingdone accordingly without being replicated on Server A temporarily.4. When A is back on-line, A needs to be brought up-to-date with Bautomatically (In other words, I shouldn't have to manually export allthe data from B to A ).Our requirements are:- The system should support Bi-directional Synchronizationbetween both the servers for their set of databases (the logging andconfiguration).- There will be constant and heavy activity in LoggingDatabase, thus if one server gets down the data should be logged andmaintained as it is on second server and on fail-back no data-lossshould occur with minimum latency time.- There could be a scenario when a server fails-over for aweek's time, there will be constant logging each second! Once itfails-back the system should rapidly synchronize the data withoutnoticeable delay among the two server database sets.- The system should also work fine if certain amount ofrecords are purged over a time period.Our concern is, observing the above scenario, how any of your SQLserver replication strategy can help us achieve the requirements.ThanksJohn
View 4 Replies
View Related
Mar 6, 2006
Simply put, I have a 'Date and Time', (06/03/2006 11:40:00), passed to the SelectCommand via the QueryString. I would like to gain data that is between the supplied time and 1 hour prior.Is there a simple way to take 1 hr off the 'Date and Time" value or is it necessary to build code that parses the string then adjusts it?
The 'Time' and 'TimeStamp' entities below are both of type 'Date and Time' and all values are gained from the same sql database. I.e. the time used as the basis for selecting the hr period is from the same database as the one where the hour period will be selected from.
Any help would be great.
SelectCommand="SELECT [Timestamp], [Volume] FROM [out8$] WHERE (([CustomerLvl1] = @CustomerLvl1) AND ([Timestamp] = @Timestamp))">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="TNT Express" Name="CustomerLvl1" QueryStringField="Cust"
Type="String" />
<asp:QueryStringParameter DefaultValue="20/02/2006 22:20:00" Name="Timestamp" QueryStringField="Time"
Type="DateTime" />
View 2 Replies
View Related
Apr 15, 2008
I've been looking into ways to accomplish a fuzzy search and SSIS makes that possible if I want to do a bulk import or something like it. But what it I just want to look stuff up at any given time not haveing to run the package?
Is it possible to expose the fuzzy lookup outside of SSIS to for example t-sql?
Here's an example:
I want to lookup the music artist "Notorious BIG" but in the database it is "Notorious B.I.G." if I use the SSIS fuzzy lookup I basically get what I'm looking for. But how would I call this from a web application? So then I tried Full text search but this doesn't really work out as well.
Will I have to re-write the logic that the fuzzy lookup uses to enable it to work? i.e. using Full Text Indexes and FreeTextTable, ContainsTable, SoundEx and the like to somewhat even come close to what the Fuzzy Lookup has?
View 6 Replies
View Related
