f



Replication - Changes to Server database's impact to local database

We have a SQLSERVER database that is replicated to many users.
We are currently in an expansion phase where we need to make changes
to the server database.  Each time we rollout a new release, we are
deleting the local replicating database and recreating.

Is there any way to automatically transfer the changes from the server
to existing local database without deleting?
0
dipillama (2)
8/18/2003 8:34:50 PM
comp.databases.ms-sqlserver 14567 articles. 0 followers. janinepelletier (108) is leader. Post Follow

1 Replies
554 Views

Similar Articles

[PageSpeed] 53

dipillama@nswccd.navy.mil (Michael diPilla) wrote in message news:<4e67e68b.0308181234.4c8e5e98@posting.google.com>...
> We have a SQLSERVER database that is replicated to many users.
> We are currently in an expansion phase where we need to make changes
> to the server database.  Each time we rollout a new release, we are
> deleting the local replicating database and recreating.
> 
> Is there any way to automatically transfer the changes from the server
> to existing local database without deleting?

It's not clear what you mean by 'changes' - changes to table
structures can be replicated if you make them through the publication
properties dialogue.

I'd suggest you post this in microsoft.public.sqlserver.replication,
as you'll probably get a better answer there.

Simon
0
sql (2120)
8/19/2003 8:36:27 AM
Reply:

Similar Artilces:

Database Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Database Database Database Software Cheap
Database Database Database Database Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://www.vehiclerepair.org/dbPro/dbpro.html ...

a database, is a database, is a err database
How many times can we see the same request from someone who wants to access data from a 'pick' database through what has come to be 'standard' practices (odbc, oledb) and still get the same old sloppy ' buy this proprietary utility (and above all, my services)' answer. I think most of these pick flavors should have some sort of layer (by now!) to handle this; If someone needs to do this, the service is really 'education' i.e to show them how. Lets cut the shit now and stop with this tired and silly BS and sad marketing schlock. Regards, -Jim Jim wrote: > How many times can we see the same request from someone who wants to > access data from a 'pick' database through what has come to be > 'standard' practices (odbc, oledb) > and still get the same old sloppy ' buy this proprietary utility (and > above all, my services)' answer. I think most of these pick flavors > should have some sort of layer (by now!) to handle this; If someone > needs to do this, the service is really 'education' i.e to show them > how. Lets cut the shit now and stop with this tired and silly BS and > sad marketing schlock. > > Regards, > > -Jim Jim who? I wonder? What is this? An attack on capitalism? Providing services for those who perhaps lack the time, skill, or knowledge to perform such tasks is hardly a crime. Maybe "standard" odbc and...

Database Database Database Software Cheap
Database Database Database Database Software Cheap Great Datase Software See Website Below. Ultra Easy to Learn (Typically 30 Seconds) Professional Programmable Database Ver. 2.3 2.1 Million Record Capacity, (New cond). Search Rate: 2000 / Records / Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Has Six Seperate Field Sets All Programmable. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). http://www.vehiclerepair.org/dbPro/dbpro.html ...

Database Links for replication between databases
Hello, Until now we do not want to use Database Links for security reasons. But an application needs to access informations that are on two separate DB. As we can not use an asynchrone mecanism (night job of export/import for example) the application provider would like to use Database Links. When a change occurs on the remote DB, a trigger then retrieve new informations into a dedicated table on the local DB. Question : is it an other way to do that ? Regards. ...

database driven applications: how should DBA's allow developers to mutate the database?
I'm going to take a position in this post, and I welcome support or refutation of my position. I also strongly request references to books and web links on this subject. Here it goes: A database driven application should be modelled with normalized tables with a mind towards OLTP processing. Developers can select from the database in anyway they want, but are provided no means to insert, update or delete database data. Instead, all updates and deletions are provided to the developer via stored procedures. The motivation for controlling insert/update/delete is to ensure that al...

Open a database from a database
I want to be able to open and run an Access database from within an already running one. The OpenDatabase command simply opens it but does not run the startup routine. Interestingly opening from Windows Explorer has a different meaning in that it opens and runs! What command enables me to open another database and get it to run its AutoExec macro, from code? Jim I don't know the answer, but I do know that when you use OpenDatabase the code in a startup form of that database does work. Martin "Jim Devenish" schreef in bericht news:0b4510ac-d415-4c2c-b200-7546aae178a4@gu8g2000vbb.googlegroups.com... I want to be able to open and run an Access database from within an already running one. The OpenDatabase command simply opens it but does not run the startup routine. Interestingly opening from Windows Explorer has a different meaning in that it opens and runs! What command enables me to open another database and get it to run its AutoExec macro, from code? Jim On Tue, 12 Apr 2011 13:37:41 -0700 (PDT), Jim Devenish <internet.shopping@foobox.com> wrote: Have you tried the Shell command? If you weren't using the AutoExec macro but one with another name, you could use the /X command line switch for msaccess.exe -Tom. Microsoft Access MVP >I want to be able to open and run an Access database from within an >already running one. The OpenDatabase command simply opens it but >does not run the startup routine. Interestingly opening ...

Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.
I had a databases running on SQL Server (EVALUATION VERSION). I moved it to another system running: -Windows 2000 Server -IIS 5.0 -BlueDragon Server -MSDE I applied all of the latest service packs, security updates, etc... Intalled SQL Server Web Data Administrator and .NET framework. I attached the database using sp_attach_db: >osql �U sa >password >Sp_attach_db �whatever', >@filename1 = �C:\Program Files\Microsoft SQL Server\MSSQL\Data\CollaborationTools.mdf', >@filename2 = �C:\Program Files\Microsoft SQL Server\MSSQL\Data\CollaborationTools.ldf' >go I added my datasource using the ODBC Admin Tool... Verified it using the BlueDragon Admin Datasources page.... But now I'm getting the error message: 'Could not run BEGIN TRANSACTION in database 'whatever' because the database is read-only.' Any help/guidance would be appreciated. Thanks very much. Shaun "SS" <stiznoit@yahoo.com> wrote in message news:dab7211.0404141325.6df43251@posting.google.com... > > But now I'm getting the error message: > > 'Could not run BEGIN TRANSACTION in database 'whatever' because the > database is read-only.' Unless I'm missing something, it's pretty obvious. For some reason database "whatever" has the read-only flag set. See db_options to reset. And since of course since it's read only, there's no point in allowing a transaction since you can't do anyt...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril On 10 Aug 2004, jewelk@free.fr wrote: > Hello, > > I need to copy a table from an 8i oracle database to a > sqlserver 2000 database. A few options exist. If this is one-off, just use sqlldr to drop the data to a file and then bcp to get it into SQLServer. > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? Well, I'm sure SQLServer has connectivity to Oracle? If you want to go this route, use that and do this from SQLServer. -- Galen Boyer On 10 Aug 2004 07:15:16 -0700, jewelk@free.fr (Cyril) wrote: >Hello, > >I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > >Is it possible to use the command "COPY FROM ... TO ..." ? >So, what is the correct syntax ? > > >Thanks for your help > >Cyril Read up on using the Heterogeneous Gateway to Sqlserver. -- Sybrand Bakker, Senior Oracle DBA "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100615.6371b40e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100617.6f7b9f3e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? > > > Thanks for your help > > Cyril Look into linked servers in Books Online - you can create a linked server pointing to the Oracle database, then do this: insert into dbo.MSSQLTable select col1, col2, ... from Oracle..SCHEMA.TABLE Alternatively, DTS can move data from Oracle to MSSQL. Simon ...

database layouts won't print, now database won't open
using Mac OS 10.3.4, filemaker pro 7. working with a database converted from filemaker 3. Everything seemed to be fine. Created a new table and imported data into that from another Filemaker 3 database (someone else created these). Layouts were created very easilly. I go to print a layout (label) and choose ALL and it will only print one record, no matter what I put in the print dialogue box. Open other databases and they all printed fine in similar layouts. Tried to "recover' it, thinking it was somehow corrupted (the woman was having a hard time printing it. I thought it was...

Recordset's Order and Database's Physical Order?
Hi,guys! I have a table below: CREATE TABLE rsccategory ( categoryid NUMERIC(2) IDENTITY(1,1), categoryname VARCHAR(20) NOT NULL, PRIMARY KEY(categoryid) ) Then I do: INSERT rsccategory(categoryname) VALUES('url') INSERT rsccategory(categoryname) VALUES('document') INSERT rsccategory(categoryname) VALUES('book') INSERT rsccategory(categoryname) VALUES('software') INSERT rsccategory(categoryname) VALUES('casus') INSERT rsccategory(categoryname) VALUES('project') INSERT rsccategory(categoryname) VALUES('disert') Then SELECT * FROM rsccategory in ,I can get a recordeset with the 'categoryid' in order(1,2,3,4,5,6,7) But If I change the table definition this way: categoryname VARCHAR(20) NOT NULL UNIQUE, The select result is in this order (3,5,7,2,6,4,1),and 'categoryname ' in alphabetic. Q:why the recordset's order is not the same as the first time since 'categoryid' is clustered indexed. If I change the table definition again: categoryname VARCHAR(20) NOT NULL UNIQUE CLUSTERED the result is the same as the first time. Q:'categoryname' is clustered indexed this time,why isn't in alphabetic order? I am a newbie in ms-sqlserver,or actually in database,and I do have sought for the answer for some time,but more confused,Thanks for your kind help in advan...

Can I use an O8 database as a transit database between a O9 and an O7 database?
Hi all, We will gradually migrate our application data from a O7 database to a new O9 database. The application data is also written to an O7 datawarehouse via a database link. In the intermediate period data has to be written to the O7 datawarehouse db from the old O7 application db and also from the new O9 database. I did a test to see if could do an insert from the O9 database over a database link into the O7 datawarehouse database, but this is not supported. Then I did the following: - create a dblink in the O9 database to a O8 database - create a dblink in the O8 database to the O7 database - create a synonym in the O8 database to the desired table in the O7 database - create a synonym in the O9 database to the synonym in the O8 database Now in the O9 database I inserted a record into the synonym, which indeed resulted in a record in the O7-table. Would it be a sensible solution to use an O8 database as a transit database in this way? Jaap. yes "Jaap W. van Dijk" <j.w.vandijk.removethis@hetnet.nl> wrote in message news:7fm4b05a4mbbb4jub1urin1j163jjsc7vg@4ax.com... > Hi all, > > We will gradually migrate our application data from a O7 database to a > new O9 database. The application data is also written to an O7 > datawarehouse via a database link. In the intermediate period data has > to be written to the O7 datawarehouse db from the old O7 application > db and also from the new O9 database. I did a test to see if could do >...

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS 9.x If the two systems are binary compatible the fastest method is to use onunload/onload. If the systems are not binary compatible the easiest way is to use dbexport/dbimport. Everything is well documented in the manual "IBM Informix Migration Guide". This manual covers all Informix databases from Standard Engine and Online to IDS and XPS. See http://www.ibm.com/informix/pubs zhu chao wrote: > Hi, > Sorry I am not an informix dba, and I was faced to copy a > sub-database(sorry I don't know the clear name of such concept, as > informix is like sql-server, which used multiple database) from one > informix database system to another informix database. > I know in oracle, we can use transportable tablespace, copy the > datafile and transport the metadata, and do something else. How can I > do it in informix then? Is there...

Updating online SQL 2005 database from local database
I have my first small SQl Server 2005 database developed on my local server and I have also its equivalent as an online database. I wish to update the local database (using and asp.net interface) and then to upload the data (at least the amended data, but given the small size all data should be no trouble) to the online database. I think replication is the straight answer but I have no experience of this and I am wondering what else I might use which might be less complicated. One solution is DTS (using SQL 2000 terms) but i am not sure if I can set this up (1) to overwrite existing tables and (2) not to seemingly remove identity attributes from fields set as identities. I know there are other possibilities but I would be glad of advice as to the likely best method for a small database updated perhaps once weekly or at less frequent intervals, Best wishes, John Morgan Since my first message I have investigated replication further and it does not seem as complicated as first thought and I have successfully carried out a snapshot replication on my local server. the main disadvantage of replication now seems to be that my online sql database provider charges $50 for providing a replication facility (presumably for enabling a push subscription) The payment is not significant providing replication is the way to to go for the occasional updating of an online server from my local server. Best wishes, John Morgan Tue, 30 Jan 2007 10:32:40 GMT, John Morgan <jfm@XXwoo...

How to import from external SQL database to local SQL database
Hello everyone. I have two machines that have SQL Express on them. I have developed a SQL database with two tables, and a lot of data, on my laptop. I want to copy that database and make it available to my local desktop machine. How can I export or save the database on the laptop and then import it so that I can use it on the desktop? ...

Python database 'frontends', what's available?
I'm desperately trying to move a Microsoft Access database application (a simple accounts system I wrote myself) to Linux. Python is one of my preferred programming laguages so I wonder if there are any good Python 'frameworks' for writing database applications, in particular I need good reporting and forms writing facilities. The basic database and logic/arithmetic seem fairly simple to me. -- Chris Green On May 23, 1:59=A0pm, tinn...@isbd.co.uk wrote: > I'm desperately trying to move a Microsoft Access database application > (a simple accounts system I wrote myself...

I dont have any backup of my database, but I have the mdf's and ldf's files
Im trying to recover my database using the mdf and ldf files. I dont have any backup and i have recovered two of the mdf files using a tool which "discovers" deleted files after hard drive formatting... It sounds cool, isnt it...:? :( Obviously, i get a "suspect" message when the server starts and the log file says this kind of things: =B7"Full Path\Name.MDF is not a primary database file." (This is one of the files repaired using the magic tool. =B7Error: 823, Severity: 24, State: 6 =B7"I/O error (torn page) detected during read at offset 0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the second file =B7Device activation error. The physical file name 'Full Path\Name2.mdf' may be incorrect. When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH PHYSICAL_ONLY" i get the following message : =B7Could not open FCB for invalid file ID 0 in database 'Logs'. Do you have any ideas?=20 Thank you very much...:D It sounds like the files are probably damaged beyond repair, or at least beyond the sort of repairs that you can do without help from Microsoft. If the contents of the database are valuable enough, I would call MS to see if they can help you to recover the data, otherwise you'll probably have to recreate everything. And (obviously) you should plan a backup/restore strategy and a source control system for your database code, to prevent any similar problems...

MS Access 2000 corrupt's databases
Hello. We have about 20 users in our Access databases. Sometime databases corrupts and are not available. I have to correct them. It is not nice, because you have to ask every user to close database, because other wise correcting is not possible. We have 100 Mt Cat 5 ethernet and some of the users use database via Citrix servers. Why databases corrupts and is there anything I can do to this problem? Hannu There are some things that can be done to minimize the problem. First, make sure the have the most current updates and service packs for Office, MDAC, Jet, and your operating systems. These are free downloads from Microsoft's web site. Next, make sure each local user has a front-end file on their computer, with a back-end file containing just the tables of data as a back-end on a network share. Also, make sure the users always close Access properly before they exit a session or shut down their computers. For more information on preventing corruption, you will find some good tips here. http://members.iinet.net.au/~allenbrowne/ser-25.html -- Wayne Morgan MS Access MVP "Hannu" <hannu.lappalainen@niiralankulma.fi> wrote in message news:e671227a.0408152348.192e9bea@posting.google.com... > Hello. > > We have about 20 users in our Access databases. Sometime databases > corrupts and are not available. I have to correct them. It is not > nice, because you have to ask every user to close database, because > other wise correcting i...

Displaying who's using a MS A 97 database
A 97 What's a quick way of determining who's using a FE/BE database at any given time? I'd like to display this info on the main form. I've tried reading the .ldb file and putting the results in a text box or label, but as users "log off" the .ldb file doesn't seem to reflect the fact a user has left, though it does correctly display users who join. Anyone got a nifty solution of displaying who's using a DB at any given time? Cheers! MS wrote: > A 97 > > What's a quick way of determining who's using a FE/BE database at any given > time? > > I'd like to display this info on the main form. > > I've tried reading the .ldb file and putting the results in a text box or > label, but as users "log off" the .ldb file doesn't seem to reflect the fact > a user has left, though it does correctly display users who join. > > Anyone got a nifty solution of displaying who's using a DB at any given > time? Since I use SQL Server I can use sp_who but I use this in conjunction with a table I have people really "log in" and "log out". The PK of this table being username and workstation name. Of course people can still appear logged in if they abend rather than exit normally. -- [OO=00=OO] "MS" <Email@Myemail.com> schreef in bericht = news:0ccke.12179$E7.4307@news-server.bigpond.net.au... >A 97 > I've tried reading...

Windows as a 'database' server? I /don't/ think so...
This problem occured today. Luckly it was on a test database! Windows is *not* production ready... http://www.sql-server-performance.com/sql_server_performance_audit6.asp Torn_Page_Detection Because data pages in SQL Server (8K) and NT Server or Windows Server (512 bytes) are different sizes, it is possible during power failures, or if you are have disk driver or physical disk problems, for your database to become corrupted. Here's why. Every time the operating system writes an 8K SQL Server data page to disk, it must break up the data into multiple 512 byte pages. After the f...

how to access database control of many oracle10g database instances on same server
I am on Redhat Linux 9 and using Oracle 10G (10.0.1.3?). I know how to create a Oracle database instance and use EM database control to administer the database. To access database control from a browser, Oracle asks to enter a URL: http://server_name:5500/em The URL does not specify the ORACLE_SID. I however want to create several database instances on the same box. Will Oracle automatically set up a different port (e.g., 5501) for second instance. All the documentation I have found on Oracle's web site refers to a single database instance on a server. Appreciate any pointers. Thanks a lot, Prem You need to read about Grid Control. Actually when you create your database using DBCA, it should ask you whether you want to use Grid Control or DB Console. Jining Han Jining Han wrote: > You need to read about Grid Control. Actually when you create your > database using DBCA, it should ask you whether you want to use Grid > Control or DB Console. > > Jining Han I hae read about Grid Control, but I think there is still a way to access many instnaces on the same server using database control. Prem Of course you can, a DB Console for each database, and you can choose that as your preferred approach, too. But I really think it's a waste of resources and a big inconvenience. You are probably better off with the "tradictional" desktop console. Just my 2 cents. Jining Han <premmehrotra@hotmail.com> wrote in message news:...

How is the best way to send data from local database into remote database ?
Hi gurus, I need to send data and receive data from local Oracle database into remote oracle database. Both sites connected via 128 kbps frame relay connection. The send and receive is as follow : - RECEIVE Customers data from remote Database -> this to be done if there is new or updated customer - SEND Billing data from local Database into remote database -> this is onece a week, nightly How is the best way to do this under the above mentioned bandwidth ? Thank you very much, xtanto On Sun, 19 Oct 2008 00:12:51 -0700 (PDT), krislioe@gmail.com wrote: >Hi gurus, > >I need to send data and receive data from local Oracle database into >remote oracle database. Both sites connected via 128 kbps frame relay >connection. The send and receive is as follow : > >- RECEIVE Customers data from remote Database -> this to be done if >there is new or updated customer > >- SEND Billing data from local Database into remote database -> this >is onece a week, nightly > >How is the best way to do this under the above mentioned bandwidth ? > >Thank you very much, >xtanto Once and for all: THE ORACLE DOCUMENTATION IS AT http://tahiti.oracle.com Refer to distributed databases. YOU ARE STRONGLY ADVISED TO STOP ABUSING THIS FORUM AS A FREE DOCUMENTATION ABSTRACTION SERVICE. IF YOU ARE NOT UP TO READING THE DOCUMENTATION, PLEASE QUIT YOUR JOB, AND FIND SOMETHING WHICH DOESN'T USE YOUR BRAIN, LIKE CLEANING STREETS. BUT BY ALL M...

database control for several database
How do we arbitrarily set the ports for each database? On Oct 25, 9:39 am, eliot06 <p.hi...@gmail.com> wrote: > How do we arbitrarily set the ports for each database? Any why would you not want to just use the default ports? On 25 oct, 18:56, EdStevens <quetico_...@yahoo.com> wrote: > On Oct 25, 9:39 am, eliot06 <p.hi...@gmail.com> wrote: > > > How do we arbitrarily set the ports for each database? > > Any why would you not want to just use the default ports? yes i want, but how can i do to find them ? On Oct 25, 11:09 am, eliot06 <p.hi...@gmail.com> wrote: > On 25 oct, 18:56, EdStevens <quetico_...@yahoo.com> wrote: > > > On Oct 25, 9:39 am, eliot06 <p.hi...@gmail.com> wrote: > > > > How do we arbitrarily set the ports for each database? > > > Any why would you not want to just use the default ports? > > yes i want, but how can i do to find them ? Are you talking about this: http://download.oracle.com/docs/cd/B19306_01/em.102/b40002/structure.htm#sthref90 jg -- @home.com is bogus. "Single women come home, look in the refrigerator, then go to bed. Married women come home, look in the bedroom, then go to the refrigerator." - heard on radio. ...

Extracting a Database to a seperate Database
Is it possible to extract part of a database and create it in a seperate database? I have a large database and would like to take about 10 screens out and put them into a seperate file? Is there a quick and easy way of doing this or must I delete and re-create the new database? Falcon in article Pnh1c.8696$Db4.1479@news-binary.blueyonder.co.uk, Falcon at ernie-no-spam-faulkner@blueyonder.co.uk wrote on 3/3/04 4:18 AM: > Is it possible to extract part of a database and create it in a seperate > database? > > I have a large database and would like to take about 10 screens out...

Web resources about - Replication - Changes to Server database's impact to local database - comp.databases.ms-sqlserver

Resources last updated: 3/22/2016 11:01:07 AM