Sycn Databases From Different Parts Of The World

Mar 28, 2008

Hi all,
New to replication
I need suggestions on how go about keeping 2 sql servers from different parts of the world to be in sync all times, some latency may be accepted.

Here is the senario,
we have website hosted in NA and customers from all parts of the world log in to oursystem and does what ever they have to do which will update the sql server databases. as our company is expanding we want to have a same website hosted in eu, so when ever a person logs from eu he will be hitting the webservers in eu and anything he do will go to the SQL database servers that are in eu. Now the problem i have is when one site goes down say NA site goes down, we need to route all the traffic to site in EU that means sql servers in EU. This brings the challenge of both the servers need to be in sync all times.

I did some research on merge replication, this might not work because in this concept we have to make 1 server as the master and the others as slaves. Also i need to think in a way that if they want to expand more that means to asia, i will be having another server, these all need to be in Sync.

We are using SQL Server 2005 standard edition.
I was reading that this can be achived easily with peer-to-peer replication,but is only available in Enterprise edition which is 4times the cost of standard edition.My company is not going to agree for this, so got to do the research and propose a solution


Any help will be greatly appreciated

View 2 Replies


ADVERTISEMENT

Hello World: SQL Server + ASP.NET

Mar 15, 2006

Hi everybody,
This is propably very silly question...
I've used SQL Server for sometime now, but always through tools supplied by my hosts (my Little Admin, SQL Server Web Admin).
I always wanted to try running the real thing, so I've installed SQL Server 2K developer edition on my machine. I also have IIS and .NET framework running.
What would be the next step to see those 3 components in action? I have noticed Northwind database in the Enterprise Manager. How do I make the connection?
I have the SQL Server Service Manager running fine, but when I open Query Analyzer it comes up with the window "Connect to SQL Server" and this little dropdown, where you can choose the server is actually empty. What do I do?
Thank you all for your pointers.

View 1 Replies View Related

It's Really A Strange World Over In....

Jul 16, 2007

...the Access forum...so many bad practices

Like this one

http://www.dbforums.com/showthread.php?p=6284279&posted=1#post6284279

View 12 Replies View Related

DB Web Access From Around The World

Mar 29, 2004

Here's a nice little scenario:

Say you have users who would be accessing a SQL Server database over the web from around the world (mainly the US, Japan, and UK), and you wanted to make the access as fast as possible.

Say also you have a couple of million dollars for hardware and software.

What architectures would you build?

Thanks.

Henry

View 3 Replies View Related

World Week

Apr 13, 2008

Hi, I have a table ABC. It has 2 columns, A and B. At column A i have 3 rows, Week,Goal,Used. Let say for column B at row Week is WW15 now, after 7 days i want the row to be updated to WW16. How do i do that? Advice please.

View 14 Replies View Related

Hello World: SQL Server + ASP.NET

Mar 15, 2006

Hi everybody,

This is propably very silly question...

I've used SQL Server for sometime now, but always through tools supplied by my hosts (my Little Admin, SQL Server Web Admin).

I always wanted to try running the real thing, so I've installed SQL Server 2K developer edition on my machine. I also have IIS and .NET framework running.

What would be the next step to see those 3 components in action? I have noticed Northwind database in the Enterprise Manager. How do I make the connection?

I have the SQL Server Service Manager running fine, but when I open Query Analyzer it comes up with the window "Connect to SQL Server" and this little dropdown, where you can choose the server is actually empty. What do I do?


Thank you all for your pointers.

View 2 Replies View Related

Hello Model World?

Dec 18, 2007

Hi!
I want to get hole through to Analysis Services 2005
from MS SQL Server 2005 with openquery,
so I created linked server (MSOLAP).
How to test that I can access an "database" on Analysis Services Server?

Something like select * from openquery(linked_olap, getdate())
or openquery(linked_olap, 'print hello world')
or openquery(linked_olap, select results from dataminingmodelCreatedWithVstudio)
?
Thanks
Bjørn

View 4 Replies View Related

Handling World Time With SQL And ASP.NET

Mar 24, 2004

Hi,

I would like to capture date time in my SQL during a certain operation. This piece of data will be displayed to an ASP.NET page.

When displaying the date time, I want it converted to the local time zone equivalent as set in the user's operating system.

What setup do I need on the SQL and the coding in the ASP.NET page?

Thanks.

View 2 Replies View Related

In The World Of J2EE, What Are JSF Component That

Aug 7, 2005

In the world of J2EE, What are JSF component that maps to
the .Net list components?

View 1 Replies View Related

Stored Procedures: How In The World Do I Use These Things?

Apr 11, 2008

I was told I can use them with SQLDataSources, but I have no clue how to do it.
I believe I have managed to set up the querry in the datasource correctly, but what do I need to do to actually use it in my VB code?
 
Any help is appreciated, and any tutorials you've found to be usefull on the subject are sure to help.
Thanks

View 3 Replies View Related

SSRS Report With Geographic World Map

Jan 3, 2014

I am creating a SSRS report with geographic world map. I am able to to download few shape files and use them.

However, the maps which i have downloaded misses few locations (for e.g. South Sudan which was formed few years back).

Where can i find the latest world map shape file?

View 3 Replies View Related

Real World: Backup Strategy And Implementation, How?

Jan 24, 2007

Real World: Backup Strategy and implementation, how?
A quote:

€œReal World:

Whether you back up to tape or disk drive, you should use the tape rotation technique. Create multiple sets, and then write to these sets on a rotating basis. With a disk drive, for example, you could create these back files on different network drives and use them as follows:


//servername/data1drive/backups/AWorks_Set1.bak. Used in week 1, 3, 5 and so on for full and differential backups.
//servername/data2drive/backups/AWorks_Set2.bak. Used in week 2, 4, 6 and so on for full and differential backups.
//servername/data3drive/backups/AWorks_Set3.bak. Used in the first week of the month for full and differential backups.
//servername/data4drive/backups/AWorks_Set4.bak. Used in the first week of the quarter for full and differential backups.

Do not forget that each time you start a new rotation on a tape set, you should overwrite the existing media. For example, you would append all backups in week 1. Then, when starting the next rotation in week 3, you would overwrite the existing media for the first backup and then append the remaining backups for the week.€?

I understand these concepts, however in €˜the real world€™ how do you go about implementing these jobs in SQL2K and how on earth do you schedule the tasks to overwrite, for example, week 1, when on week 3€™s rotation.

Could I have real world examples or scripts for the jobs that would carry out this task? It appears that whatever course you do, it does not fully cover the above, and I have only worked on my own and never with a DBA, so I have never seen this implemented in any environment.

I would like full details on this please, as I need to get my head around it.

Thanks

Neil

View 6 Replies View Related

I Want Send All Kind Of Phones Arround World

Apr 29, 2007

hai,



I Want to send SMS all kind of phones arround the world,so what can i do for that pls help me...............

View 9 Replies View Related

Select * && Table Name Issue (Reserve World)

Aug 21, 2006

Hi All,

We are trying to read a table name Order through command line SQLcmd.
But it is giving us an error. Order is an SQl2005 reserver word and app programmer created that table who left. No we have problem to read that table through sqlcmd. any ide a how we can do that.

C:>sqlcmd
1> use ACCMedford
2> select * from 'Order'

3> go

Msg 102, Level 15, State 1, Server ACCMedford, Line 2
Incorrect syntax near 'Order'.

1> select * from "order"
2> go

Msg 102, Level 15, State 1, Server ACCMedford,, Line 2
Incorrect syntax near 'order'.

1> select * from order
2> go

Msg 156, Level 15, State 1, Server ACCMedford,, Line 1
Incorrect syntax near the keyword 'order'.



View 6 Replies View Related

Table Partitioning Design In Actual World

May 23, 2008

I have gone through the table partitioning in MSDN, like Designing Partitions to Manage Subsets of Data . But how to do this in actual world, since some db need to partition for 7 days, then archive these days records on the 8th day, while other prefer 14 days/monthly, and run this repetitively for many years? If this is running weekly, how can i generate the scheme and function dynamically? What if ID for row count is not viable?

Sure this will not work:




Code Snippet
CREATE PARTITION FUNCTION [TransactionRangePF1] (datetime)
AS RANGE RIGHT FOR VALUES ('10/01/2003', '10/02/2003', '10/03/2003',
'10/04/2004', '10/05/2004', '10/06/2004', '10/07/2004');
GO





Then how to drop partition periodically?

View 6 Replies View Related

Security Of Viewing The Reports Manager From The Outside World

Aug 31, 2007

How do you stop anyone from the outside world from viewing the report manager?

From typing eg( www.mywebaspreportapp.com/Reports) and directly accessing the report manager?

Is there a security step i missed somewhere?

View 2 Replies View Related

MSDE Or SQL 2005 Deployment Resources - Real World Input

Feb 9, 2006

I have traditionally done web app and client server programming and am have been playing around with a new tool (Win forms) app that I eventually want to distribute to other developers and a couple of business people in our organization. I have done apps in the past that all connect to a central server for data access. The I'm working on now will have an individual DB per user and should be available locally for a desktop version of the software.

I am looking for more resources on things to consider when deploying an app with either MSDE or SQL 2005 Express. More specifically, items like long term maintenance of the db once it's installed with the user, etc. (DB bloat, transaction files, auto maintenance routines I may want to build in, etc)

I have seen all of the msdn docs on what you need to deploy (and how to do it), but I'm looking fro input from people that have deployed it and any significant pitfalls they have run into with that sort of deployment.

Any links or book references would be appreciated, thank you,

Cy Huckaba

View 1 Replies View Related

Web Parts Without Personalization

Aug 17, 2007

i am using web parts with drag and drop feature , i did not use aspnetdb  for user membership
 while it is published it gives eror as follows
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:

If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
Please give me ur valuable advice , thanks in advance

View 2 Replies View Related

What's The Best Way To Dupe Certain Parts Of My RS?

May 29, 2002

Hi!
Mgmt just decided that the designer (me) was more valuable than the developer (now me). I hope there are some gurus out there who can help.

What would be the best way to duplicate certain parts of my RS? Suppose
I have a table with three columns: ID, adName, and priority. When I serve the ads, I am randomizing them, but would like to serve some more frequently than others. I am hoping there is a single query I can use, that will seed the RS with multiple instances of high-priority records.

Should I stick to play-doh?

View 1 Replies View Related

Date Parts In SQL V6.5

Mar 10, 2003

I am still using SQLv 6.5 and have a need to do monthly reports. It is my understanding that there is no inherent capability in SQL v6.5 for functions such as MONTH getdate() as exist in SQL 2000. Does anyone know of a script that will simulate this so I can extract information from a database such as date_last_update IN MONTH 02?

Thanks

Dale

View 3 Replies View Related

SQL Pieces-parts

Jul 20, 2005

I'm very familiar with Oracle at a conceptual level and need tounderstand MSSQL as well. Can anyone point me to a document/web pagethat describes the different files used in MSSQL and a discussion of howthey relate? (ex. with Oracle, there is tempdb, redo, archive, db files,rollback, etc.)

View 4 Replies View Related

SSAS Data Mining: Using The Time Series Model In A Real World Scenario.

Mar 15, 2008



I probably posted my question in the wrong forum so please check here:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3009605&SiteID=17

thanks

View 6 Replies View Related

Getting Parts Of DateTime Field

Jun 8, 2008

Hi everyone,
I want to get year, month, day and time parts of a DateTime field in sql,
Can help me?

View 1 Replies View Related

Tell Me Some Third Parts Monitoring Tools

Mar 15, 2002

Hi, gurus:

Please tell me some third parts monitoring tools for MS SQL server 2000.

View 1 Replies View Related

Splitting Dataset In 2 Parts

Mar 22, 2012

I have 5 records in a table called "testing" as such:

LetterCdcontact_id
x1
x2
x3
x4
x5

How can I split this dataset so that three records have LetterCd = 'y' and the other 2 records have LetterCd = 'x'? The number of records can vary, but the idea is the same: split the values in the LetterCd column evenly (50% = 'x', 50% = 'y'). LetterCd is varchar(25) and contact_id is int. I can't update the data, it would have to be a SELECT statement with some sort of CASE statement to get the remainder of the record count?

View 8 Replies View Related

Deleting Parts Of A String

Mar 18, 2014

The issue is that I need to delete parts of this string using SQL Server.This string is a title of a document which should contain only the Document Category & Title. Instead, it is displaying extra parts such as Year, Date Created, etc. I would like to truncate/parse off the title. The database is Acme_system. The name of the table is dbo.documents, the column name for the title is "title" and there is also column is "childcat".

The title string reads:

2013-730-DAILY NOTES AND TRACKING FORM-11-16-13 700-030714

I want to take off everything except for "DAILY NOTES AND TRACKING FORM-11-16-13 700"

View 9 Replies View Related

Select Parts Of Information

Apr 20, 2008

Hey guys,

I was wondering if this is possible I have to be able to just select the number before the '-' in acolumn which is formatted like 123-456 so I just need the the 123 part.

Any ideas how this can be achieved?

Thanks.

View 6 Replies View Related

Deleting Parts Of String

Mar 18, 2014

The issue is that I need to delete parts of this string using SQL Server.

This string is a title of a document which should contain only the Document Category & Title. Instead, it is displaying extra parts such as Year, Date Created, etc. I would like to truncate/parse off the title. The database is Acme_system. The name of the table is dbo.documents, the column name for the title is "title" and there is also column is "childcat".

The title string reads:

2013-730-DAILY NOTES AND TRACKING FORM-11-16-13 700-030714

I want to take off everything except for "DAILY NOTES AND TRACKING FORM-11-16-13 700"

View 3 Replies View Related

Selecting Parts Of Data

Apr 20, 2008

Hey guys,

I was wondering if this is possible I have to be able to just select the number before the '-' in acolumn which is formatted like 123-456 so I just need the the 123 part.

Any ideas how this can be achieved?

Thanks.

View 8 Replies View Related

RS Web Parts On SharePoint 2007

Feb 20, 2007

Hi,

I'm having troubles connecting the webparts on SharePoint 2007. I installed the RSWebParts package from SQL Server 2005 Reporting Services on my MOSS 2007 box. The installation went smoothly and I can add both Report Explorer and Report Viewer on a page. But when I try to connect RE to RV I get the following error:


An unexpected error has occurred.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.

So I have to go to the maintenance page and remove the web parts.

Have anyone managed to bypass this and make them work together?

Thanks,

View 1 Replies View Related

Sending Parts Of The Report

Feb 22, 2008



Hi,

I prepared a report including sale information of a company. There are different offices of the company in different locations. And in each offices there are more than 1 saleman. I have to send the report (but just the associated part of the report to the saleman, not the whole one) to each saleman and his/her manager. I prepared a subscriber data (name and mail addy) for each office. How can i send the associated part of the report to the salemen and his/her manager by using just the original report (I dont wanna seperate the report depending on the saleman and send each report one by one, cuz there are many offices and salemen)


Thank you

View 7 Replies View Related

Secure Parts Of A Table

Sep 30, 2007

This is the thread
http://msdn2.microsoft.com/en-us/library/ms998292.aspx

Here it mentions the following
Deployment Considerations
When using Windows authentication to connect to SQL Server in production
environments, consider the following:

Use a custom service account.
Create a SQL Server login for a Windows group.
Assign database permissions to a database role.
Use a Custom Service Account

This is my problem we are trying to convert all our web pages to use Windows Authenication.
DOMAINWEBGROUP (for example).

Tracey and Jack part of this group
But sometimes there may be anothers added to this say John

The security comes from SQL right now i give data reader to the database.

Example
1. ASP.NET uses the service account DOMAINWEBGROUP
2. Assign WEBGROUP to database PERSONEL
Table Employees
Salary
Web Page
Lets say Tracey logs into the web page.....and i have two pages
1. Employess
2. Salary

As the WEBGROUP is data reader viola Tracey sees all salary information.
Im trying to figure out that only Tracey can see Employees

But im not seeing the relationship when using WEBGROUP

Is there a way in SQL to say yes we have the DOMAINWEBGROUP
but in sql also put in Tracey and know that Tracey is part of DOMAINWEBGROUP
So that in my tables i can only give tracey part of this employee table (say the first name last name) and not salary information. (I know how to use the roles).

The part im confused about is the mapping WEBGROUP to tracey in sql as the web developers only pass in WEBGROUP

View 6 Replies View Related

Can I Cause Parts Of The Report To NOT Print?

Apr 30, 2008


I want to add some information to a report that I do NOT want to be included in the printed output. Is there any way to designate a rectangle or list or table to NOT print?

Thanks.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved