Synch-ing Databases
May 13, 2002
Hi all,
Heres the deal -
I have several remote users - all running the same program, with a local copy of MSDE...
I would like to setup a master server at my office that will act as a repository for the data that is generated at the remote sites.
I would like the remote users to establish a connection with the server (tcp/ip) and upload all the data they have entered into the local database.
They do not need to download any data - this is accomplished through the web services of SQLXML -
they just need to upload all the data they have, without destroying the data from before.
I have some concerns on the auto-inc that is used in the tables now and how they will react to each other in the master database...
thanks for any help
take care
tony
View 2 Replies
ADVERTISEMENT
Apr 17, 2006
Hello,
I would like to request you to kindly point me to a location where I may obtain more ideas/suggetions/details on how synchronization may be performed in a real world scenario ?
MS has been promoting smart clients and offline availability, but I cant seem to find any material that outlines some ideas/techniques/pointers as to how this may be acheived sans SQL Server replication
Essentially, what I'm looking for is someting that would guide a not-so-solid-with-databases person like me through how synchronization (sans sql replication engine) may be implemented - any watchouts etc..
Regards,
Avinash
View 5 Replies
View Related
Jan 10, 2005
Hi all, here are my goals: Have the same DB on two different stand-alone computers, and keep them up-to-date from each other.
Basically a user would input to a DB for a week. Then every week or two, update the other stand alone DB with the new input. The DB would be exactly the same.
What are my options for this? I'd like it as easy as possible! Are there any software packages that deal with this type of transfer, etc.? Thank you!
View 5 Replies
View Related
Jul 23, 2005
I have to schedule the automatic restore the standby database fortesting backups . The database was already in log shipping mode. Up towhat point do I need to restore the database without affecting the logshipping sequence? Can we query the log shipping tables for the lastscn applied and recover up to that point? Any suggestoions are welcome.ThanksTram
View 1 Replies
View Related
Nov 9, 2007
All,I have an Access DB. On a nightly basis, I want to look at an OtherDB (not Access, but SQL) and:+ Add any new records from Other.Clients into Access.Clients
Quote:
View 1 Replies
View Related
Apr 25, 2002
Hi all,
We are going to have several dozen servers around the country- each with a mirror copy of the initial database (blank) loaded upon them.
The data will be entered at each station, and then once a month, the systems will dial into the 'net and -
this is where i am getting stuck -
we would like the data from the remote areas to update the data in the master database -
What would be the best solution to update the data from the remote station into the master database???
thanks
tony
View 1 Replies
View Related
Sep 8, 2006
we have a merg replication running in three regions UK,USA and AU
my question is in one of our test environment testers managed to get a few tables out of synch while the replication is out.
we have re-established the replication since then and it worked fine untill they try to update records from those out of synch tables. as usual we get conflicts.
we don't really know how many tables are out of synch either. we have about 500 tables.
is there a way to synch tables from with in the merge replication??
View 5 Replies
View Related
Mar 28, 2006
Hi Everyone
As most of you do, I am eagerly awaiting the ability to synchronize my sql mobile database on the hand held to a local sql express database on my local machine
I know users in Microsoft have pointed out to us that we are getting things for free.
At the same time, Microsoft is getting our patience for free and at a cost to us developers.
Its nearly April and as one article says Microsoft will release a fix for this inadequacy
Microsoft...we are happy to pay for this. Palm offers it so what is the big deal. Its not the
reinvention of the wheel. We would have liked that instead of the server synchronization
that bypasses the local sql express database
I as many others are happy to pay
Please let us know when you will be addressing this problem.
I would appreciate the feedback and frustration of other developers. Maybe this will show them we are really running out of time with our clients
Regards
Touraj
View 13 Replies
View Related
Jan 30, 2008
Hi ... I am converting SqlServer 2000 databases to SqlServer 2005. It is working great for the most part.
The issue I am having is that a user with a schema that owns objects is established in the database and no user is defined in the instance logins. I can see where if I add the instance login then the Principal_id does not match. Cannot drop the user/schema as there are referenced objects.
I got around this in SqlServer 2000 by updating the IDs to match but now they are views and updating is not allowed.
Is there a straightforward way to resynch the database user to a newly created login?
Thanks,
John
View 4 Replies
View Related
Jul 20, 2005
Hi,I had this problem in version 7 and dont remneber How I solved it!!I have installed a local SQL Server (2000 aka version 8) on myWorksation (W2K), I have picked NT authuntication.Everything was fine untill I changed my password. Now SQL server cannot start because it fails to login. The old password is embeddedsomwhere and I cant egt to it!!!My workstation is on a network, so the password is my networkpassword.Everythinng is MS on our network.Any help would be appreciated.ThanksFardad
View 1 Replies
View Related
Jul 20, 2005
Hello,I'm relatively new to the database world so please forgive me inadvance for my ignorance. I have recently been tasked at my job withfinding a tool that will perform the following tasks: 1) extractschemas from a db, 2) produce a difference report between schemas fromtwo databases, and 3) synchronize two schemas. The purpose is forproduct upgrades during which an existing database schema will need tobe synchronized with a baseline schema.The tool must support the following database vendors (versions givenin parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS2000, and IBM DB2 (7/8).I have spent the last several days downloading and researching avariety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer,DBDiff, and AdeptSQL. I thought it would be a good idea to post amessage to a few database newsgroups and ask for any recommendationsdatabase developers may have.So if anyone has any recommendations on such a tool or softwarepackage, I would greatly appreciate any information.Thanks!Chad Smith
View 9 Replies
View Related
Oct 10, 2007
We are trying to set up Web Synchronization, but we keep getting the error "IIS ws not found on the web server. Please specify a computer name that has IIS installed".
Our Distributor/Publisher are on one box, IIS on aother box. Both boxes are in the same domain (test environment), and both boxes are being logged into with a domain account.
We can get this to work in another similar environment so we don't know why this one isn't working. Is it permission issues?
Thanks...
View 1 Replies
View Related
Mar 12, 2007
Dear all,
I am running into a null reference exception on replication with SQL Server 2005 Compact Edition. The problem occurs at repl.synchronize(). Even though the statement is inside a try-catch block, the exception is not caught, and the application quits.
Device O/S: Windows Mobile 5.0 v 5.1.195 Build 14957.2.3.1
Hardware: Dell Axim X51v, Intel PXA270
Database: SQL 2005 SP2 (no post SP2-patches)
Exception shows as "an unexpected error has occured in AppName.exe. Select Quit and then restart this program, or select Details for more information." Details:
.. at NullReferenceException at AppName.Form1.Synch()
.. at .... (various lines)
.. at AppName.Form1.Main()
The application is based on the tutorial (Creating a Mobile Application with SQL Server Compact Edition) at http://msdn2.microsoft.com/en-us/library/ms171908.aspx.
The application was successfully working initially but then stopped working on replication after some minor modifications which were not related to the replication code, e.g. adding some buttons to the form.
Three things are puzzling me here..
1. The fact that this is a NullReferenceException and not a SqlCeException
2. Why the try-catch block doesn't work
3. Why the exception occurs
Is this a bug or am I doing something wrong here?
Any help would be appreciated.
Code sample below:
Sub Synch()
Try
LogMsg("Deleting db...")
DeleteDB()
LogMsg("Initializing repl...")
Dim repl As New SqlCeReplication
repl.InternetUrl = http://192.168.0.100/SQLMobile/sqlcesa30.dll
repl.Publisher = "TRKSRV"
repl.PublisherDatabase = "trk_db"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "Trk"
repl.Subscriber = "Trk"
repl.SubscriberConnectionString = "Data Source=""Program FilesTrk2007DefectTrk.sdf"";Max Database Size=128;Default Lock Escalation =100;"
LogMsg("Adding subscription...")
repl.AddSubscription(AddOption.CreateDatabase)
LogMsg("Synch...")
repl.Synchronize()
LogMsg("Cleanup...")
repl = Nothing
Catch err As SqlCeException
MessageBox.Show(err.ToString & " " & err.HResult & " " & err.NativeError & " " & err.Message & " " & err.InnerException.ToString)
Catch err2 As Exception
MessageBox.Show(err2.ToString & " " & err2.Message.ToString & " " & err2.InnerException.ToString)
End Try
End Sub
View 1 Replies
View Related
Jan 30, 2008
Greetings!
I would like to create a database for keeping track of payroll data for employees where the supervisors (job coaches) on our workshop floor can use a Pocket PC device to record the hourly employee data on the fly. Then at the end of the day, the supervisor can place the device in a cradle of some sort and synch the newly entered data into the main database.
I'm guessing that SQL Server Compact edition would be perfect for this type of task? Is that correct? Can someone give me recommendations on how to go about setting this up? What should I use as the main database? SQL Server? Access? Any advice is appreciated!
View 1 Replies
View Related
Jan 18, 2008
I was hoping someone could help me with a question. I have a server that has a table with 5.6 million rows of data. I want to use DTS to transfer all the rows in the table from one SQL server to another via DTS, which I have got to work correctly. The problem I'm having is when I run the DTS job the 2nd time, it does all 5.6 million rows again and not just the deltas since the last DTS job. Is there anyway to use DTS to transfer the deltas (ex: 1000 rows since the last DTS job) from server 1 to server 2 ?
Thank you.
View 6 Replies
View Related
Jun 25, 2007
we have a table in an oracle database containing security information that is updated several times a day. the network connection into that oracle database is not always reliable. we would like to keep a copy of that table in a sql2005 database. the table will need to be refreshed 1/hr. it is a small table so performance won't be an issue.
would ssis be ideal for setting something like this up? i have never created an ssis package before (i'm an oracle dba crossing over). any pointers on how best to set this up?
thanks!
chris
View 6 Replies
View Related
Dec 10, 2007
Dear Readers,Is it possible, like in Access, to link to tables in other SQL databases that are on the same server? I have a query that I originally had in Access that queered from multiply databases. It did this by having those other tables in the other databases linked to the database that had the query.
View 3 Replies
View Related
Jan 24, 2006
I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased using the query "select is_broker_enabled from sys.databases where name = 'newdbname' " It was 1. I even tried the ALTER DATABASE SET ENABLE_BROKER. but it didnt work.
When i tried the sample on a newly created database it worked fine.
Is there any solution to make the restored database to work for service broker.
Thanks
Prashanth
View 3 Replies
View Related
Feb 8, 2000
hi from France !!!
i would like how to duplicate a database to another server with all datas, constraints, keys, indexes...
should i use sp_attach_db, dts, backup/restore, sql scripts... ???
thanks to all, nico
View 1 Replies
View Related
Mar 13, 2007
This is the scenario. Is it possible to create views or something (like Oracle DB Links) in a database in Instance 1 which can show data from another database in 2nd Instance ?
I want to do this to create reports.
View 2 Replies
View Related
Sep 24, 2006
I have created a site which now has two databases. Firstly is the ASPNETDB.MDF which I beleives get set to manage the security, logon/Roles that I have on my site. The second dataabase "MyDatabase" is one that I have created for all my data withing the site. I would like to combine this to one Database for simplicity and cost. Now I can't see the ASPNETDB.MDF when I use SQL Manager 2005 and I can't see how to change the set up of ASP.Net Configuration if I was to just use mydatabase. Any suggestions
View 1 Replies
View Related
Sep 25, 2006
Hi, I have my site set up, but have had difficulty using the data gathered by the aspnet.mdf. I wanted to use the email and username columns from the membership table to send newsletters automatically from the database(but that's a whole other post)I also have my own databse, which will be populated by information gathered from the website, so is currently empty. I'd like to take this opportunity to say that i don't think there's enough information given on how to populate a blank database from a website application. Most tuorials etc are concentrated on retrieving and displaying data, which is all well and good, once you actually have data to play with!I don't need two databases, so can I add tables to the aspnet.mdf ? But then what about relationships etc? I won't damage the current relationships by adding new ones? On the other hand can i copy the aspnet.mdf into my own database, and then assign the relevant permissions to that db? Any help would be greatly appreciated-in language for newbies please! I am relatively new to .asp.net/Visual Basic/ and SQL. It's a steep learning curve!Also....I have used create user wizard, login, password recovery etc within my site, the data is inserted into the correct db tables-without using an sql datasource for some reason...? is that right?I have also created a wizard to collect some more data (because i couldn't work out how to insert the data from the extra steps in create user wizard, into my own database) but when i click submit the data is not inserting into the specified table - (yes the connection string is fine, insert and update has been selected from the advance tab in connections wizard). Would this/could this be because i have assigned a 'finishbutton url'? should i use a Response.Redirect("blahblah.aspx") instead?
View 4 Replies
View Related
Nov 16, 2004
I am very new to asp.net, but am having trouble trying to link the asp.net page that i have created to an sql database that has been set up on a local system. Am actually trying to use the sql control to extract info from the database. Would appreciate any ideas.
View 1 Replies
View Related
Jul 13, 2001
Dear friends,
There are two databases in SQL Server and I have to designed the view or store procedure joing tables from two databases. How ? It will be kind, if you give me answer with detail example.
Best regards!
manoj
View 1 Replies
View Related
Jul 16, 2000
Hello,
I’m using VB6 as the client and MS SQL Server 7 as the database. The company I’m consulting for has a proven track record for marketing and getting millions of customers. The parent company would like to create two new companies selling the same product; with 1 million customers per company. How many records can MS SQL Server 7 handle? I’ve been told it can handle 4 terabytes. What does 4 terabytes translate into records? I have already set up an application for company #1. Should I put company #2 in the same MS SQL Server database? Or should I put company #2 in a different database? My VB Application and SQL Server database were designed to handle multiple companies selling the same product. For performance sake; would it be better to separate the databases? Any suggestions? Is anyone currently using MS SQL Server with 2 or more million records?
Thanks,
Denise
View 2 Replies
View Related
Aug 3, 2000
I am presenting using MS SQL 6.5 and have used up all my (VDEVNO) device numbers (1-255). Will I have this problem when I migrate to SQL 7? I understand SQL 7 does not use a device when creating databases, so what
is the maximum number of databases I can create in SQL 7?
Thanks in advance.
View 4 Replies
View Related
Apr 9, 2005
Gusy im currently making and app that runs from a cd rom yet it uses databases made in sql and i already made the part for ataching the database from the cd but i haven't been able to do 2 things:
1. Can i actually attach my database from a cd without any need for the computer
2. does anyone has the code for detaching a database in Sql in c#
thanks ahead
View 6 Replies
View Related
Jul 30, 2004
How can you make two databases communicate with each other?? they both reside in sql server 2000. How would I go about doing that. Access 2000 is the interface
View 3 Replies
View Related
May 21, 2004
Hello,
Is it possible to restore a 6.5 database to a 7.0? I backup the entire 6.5 database to a BAK file then tried to restore it to SQL 7.0 but it didn't work. SQL 7.0 states that the disk device is not a valid Microsoft Tape Format backup set.
We have an application that was developped long long time ago by a old team and I don't want to upgrade the server. I tried to build a second 6.5 server (new hardware) but I couldn't restore the database as SQL 6.5 states that the server is in single user mode. I don't know how to switch to multi users mode. The database I want to restore is not in DBO or single user mode.
Any help will be appreciated.
Thanks.
Toan.
View 1 Replies
View Related
Mar 16, 2006
Hello,
Can someone show me the TSQL I need to write in order to create 100 SQL databases in one go.
I want them to be called DB1, DB2, DB3, DB4...etc etc
I know how to create one database;
---------------------------------------------------
USE MASTER
GO
CREATE DATABASE DB1
ON PRIMARY
(
NAME = DB1_dat,
FILENAME = 'C:Program FilesMicrosoft SQL ServerMSSQLDataDB1.mdf',
SIZE=4,
MAXSIZE=10,
FILEGROWTH=1
)
-------------------------
But I don't want to do this 100 times,
Thanks in advance
ICW
View 20 Replies
View Related
Feb 10, 2007
i really want to know,there are how types of databases?how many types of servers?how many types of inernet based languages?
View 2 Replies
View Related
Jul 20, 2005
Hello,I am currently looking for databases that contain available prescriptionmedications and diagnosis codes (i.e. ICD9 medical diagnosis codes) thathave been created using SQL.Anybody know of companies that have these commerically available?Thanks,Eric
View 1 Replies
View Related
Oct 20, 2007
I'm writing an app in vs2005 using sql express. This may be the wrong forum for this question, but here it is. I'm going to have several tables: Seven for Customer information, six for Employee information, 15 for Misc Definitions (status types, skill types, discipline types, gender types, etc.) and 10 for Scheduling information. This is a total of 38 tables.
Is there any advantage to having four databases, one for each type, or should I put all 38 tables in one database and add relationships to everything?
View 5 Replies
View Related
