How To Tranfer Data Between Two Server Without REPLICATION???
Apr 21, 1999I need to transfert data between two servers without replication, and using a stored procedure . Any Ideas. Thanks.
View 1 Replies
ADVERTISEMENT
Tranfer Of Data In The Table From One Server To Another
Jun 14, 2007I have SQL server 2005 in which I have two Server (1 & 2).
There is a table, userLookUp in a database of Server 1, with huge data.
I created a table, called userLookUp on server 2 with same number of colums and same dataType.Now I want to get the data from the table in the server1 to the table I have created in the server2.
How ?????
Tranfer Data To The Another Table
Aug 11, 2005hello..
my have 2 tables..
tak_1
and
tak_2
they have the same colums, they are twins
how to transfer datas from tak_1 to tak_2 ?
I need something like below
Quote:
transfer data (select * tak_1 where date='10.10.2004') to tak_2
How To Tranfer Excel Data To Sqlserver2000 ?
Sep 29, 2005In our project we r having a task such that to convert the excel data to sqlserver2000 . what is the procedure ? (Bulk amount of data )
View 2 Replies View RelatedHow Do I Tranfer A Previous Table And Its Data To The ASPNETDB.MDF In The Web Site Administration Tool.
Dec 29, 2006How do I tranfer a previous table and its data to the ASPNETDB.MDF in the Web Site Administration tool. I've tried right, but I can't locate the database in the SQL server on my server. help please.
View 1 Replies View RelatedTranfer Data In One Table To Another Table.
Dec 29, 2006This may be simple, I just want to tranfer about 15 columns of data into another table on the same database. The receiving database is empty, but has different column names. I'm guess I have to make sure the data type can hold the information being transfered. I'm using SQl Server 2005. Please help.
View 20 Replies View RelatedUrget - Database Tranfer
May 4, 2001hello
i want to tranfer the database from one machine to another machine,
which are not in one network.
so please tell me how to tranfer the database
it is urget
thank you.
dilraj
Unable To Tranfer Jobs From Sql2000 To Sql2005
Nov 20, 2007Hi
Im in the process of upgrading my sqlserver 2000 to 2005.I want to migrate all the jobs from sql2000 to 2005.
I scripted the job (right click job--->all tasks--->generate sqlscript).
I ran the same script on sql2005,i was getting an error like this
"Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
The statement has been terminated."
What does the error mean? cant i run the same script generated in sql2000 on sql2005.
Wht is the approach to transfer the jobs from sql2000 to sql2005 ?
I know ther is one more way i can transfer.It is through sqlserver business intelligence development studio and using transfer job task.But i dont want to use that.I want to script the job and execute it on sql2005.
Regards
Arvind
Replication Of DB2 Data On SQL Server
Mar 9, 2007What tools are available to update SQL Server application tables from a DB2 database?
The DB2 database is on iSeries (AS/400).
Thanks in advance.
SQL Server 2000 Data Replication
Apr 5, 2007I want to replicate SQL Server 2000 data from publisher to subscriber with new data added and existing data modify at subscriber, is it possible? what is the solution.
SQL Server 2008 :: Archive Data Through Replication
May 5, 2015I'm looking for a process to archive data through replication. I have nightly job that purge records in few source tables(publisher) retaining only 3 yrs data. I have archive database (subscriber) that contains prior 3 yrs data and current 3 yrs data.
Before nightly job DELETES records in Source table i want to STOP replication so that the delete is not replicated in archive database. After the job completes i would like to TURN ON replication so that any new inserts and updates in Source will ONLY be replicated in archive database.
My DBA tested this but after last step of turning replication back ON archive database is sync'd with source table.
There are around 70 tables where 30 of them are transactional tables that needs record purge. Developing ETL process is possible but tedious.
Info On Data Replication On Sql Server 2000.
Jul 20, 2005Hi,I'm in need of detailed information on how data replication works on thesql server 2000. If someone knows about a book or articles thatdescribes how data replication works with transactions, storedprocedures and/or merging databases I would like to be pointed in theright direction./Zero_Addiction.
View 1 Replies View RelatedTransport Data From Progress DB To Server With Replication?
Jun 1, 2015We are working on a project but have some problems. There is a Progress Database and we want to use sql server data replication but we don't know, Can Sql Server support data replication for Progress Database?
View 2 Replies View RelatedTransfer Data Between SQL CE AND SQL SERVER Without Merge Replication
Jan 25, 2008I've got a problem:
I want to transfer data between an sql server 2005 and my pocket pc. So i've installed a sql server CE on it.
I know that i can use the merge replication but, i don't have any IIS. So, i've got to transmit data though email that have got a file attached. I Know how to email from sql server 2005. When the pocket receive that email, i don't know how to insert the data in sql ce from outlook compact. Doi have tu use SSIS , in that case how can i run the package?
thanks
SQL Express Replication And Problems Accessing Data After Replication
Jul 28, 2006Hi,
I have a VB.net app that access a SQL Express database. I have transactional repliaction set up on a SQL 2000 database (the publisher) and a pull subscription from the VB.net app. I use RMO in the VB app to connect to the publisher. My problem is I am getting some strange behaviour as follows
- if I run the app and invoke the pull subscription it works fine. If I then close my app and go back in, I can access my data without any problem
- If I run the app and try to access data in my SQL Express database it works fine. I can then close the app, reopen it and run the pull subscription it works fine
however.......
- if I run the app, invoke the pull subscription (which runs fine), and then try to access data in my local SQL Express database without firstly closing and reopening the app, I get a login error
- if I run the app, try to access data in my local SQL Express database (which works fine), and then try to run the pull subscription I get a "the process cannot acces the file as it is being used by another process" error. In this case I need to restart the SQL Express service to be able to run replication again.
I get exactly the same behaviour when I use the Windows Sync tool (with my app open at the same time) instead of my RMO code to replicate the data.
I am using standard ADO.Net 2 code to access my SQL Express data in the app and closing all connections etc
Any advice appreciated !
Thanks
Ronan
Transaction Replication && Data Archiving On SQL Server 2000
Jul 23, 2005Hi techiesI have set up a Transaction replication from My Primary Server toSecondary Server on Orders table.Thousand of records gets inserted on Orders every hour which getreplicated on the secondary server. it works finereporting apps uses Secondory server's Orders table data for generatingreports .The Problem :Let say if i want to Remove older records from Orders table in theprimary serverwith out reflecting this change on the secondary server.is there a way to PREVENT this operation /transaction to be propogatedto the secondary server.Note : i am moving the records to another table (orders_Archive ) anddeleteing the rows from orders table . Also I need all the rows to bepresent on the secondary server table.Please advice ASAPRegards,Raj
View 4 Replies View RelatedSQL Server Admin 2014 :: Transactional Replication With Filtered Published Data
Apr 15, 2015From distribution db, which table(s) store info about filtered data?
View 0 Replies View RelatedTransactional Replication - Updatable Subscribers - Image Data Type- Sql Server 2000
Aug 21, 2007Sql Server 2000
I am looking for bidirectional transactional replication using updatable subscribers (queued or immediate) . Is it possible to replicate the image data from the updatable subscribers to the publisher. I understood that the Image data can't be replicated to the publisher from the updatable subscriber. I am not using the WRITETEXT or UPDATETEXT. I am using just INSERT and UPDATE for image data type transactions.
Any thoughts on this is greatly appreciated.
Thanks in advance
SQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.
Sep 9, 2005Hi,
View 3 Replies View RelatedSQL Server 2005 - Transactional Replication Involving Depricated Text And Ntext Data Types
Dec 2, 2005I'm currently trying out transactional replication with updatable subscriptions across two 2005 servers.
View 3 Replies View RelatedDBCC OPENTRAN Shows REPLICATION On A Server That Is Not Configured For Replication
Aug 22, 2007Hello,
I have this problem on a Production database.
DBCC OPENTRAN shows "REPLICATION" on a server that is not configured for replication. The transaction log is almost as large as the database (40GB) with a Simple recovery model. I would like to find out how the log can be truncated in such a situation.
Thank you.
Trans Replication With Updating Subscriber On Sql2000 (single Quote In The Data As Char Data Type)
Nov 17, 2006Hi,
I am trying to setup Trans Replication with updating subscriber on sql2000. One column on few tables got data with single quote (').
How do I handle in this case? Did any one come across such case?
Can I Change default QUOTED IDENTIFIER from ' (single quote) to something else (@@@) on SQL2000?
If yes, how to do?
Thanks
mka
Data Replication - Pushing Data Updates
Oct 26, 2007Guys,
I have 14 databases, the last database - 14th one will have lookup tables only. The other 13 databases will have these lookup tables and data tables. At the end of each day I will make updates for lookup tables on 14th database, I want to be able to push the updates to any or some of the 13 databases. Look up tables will have only upto 100 rows, so I am not concerned about the bandwidth. What is the best way to accomplish this.
Any suggestions and inputs would help
Thanks
Data Replication
Jan 24, 2007I have 3 databases which i will reference as Database1, Database2 and Database3.
Database1 and Database2 are running SQL SERVER 2000
Database3 is running SQL SERVER 2005
Database1 and Database2 each have a Member Info table containing login information for seperate websites.
Database3 has a Member Info table also, but the login information is populated from the Member Info tables in Database1 and Database2.
Curently this is achieved by running a job once a day that clears out the Member Info table on Database3, and then running two insert statements that take the data from Database1's Member Info table and Database2's Member Info table and insert it into Database3's Member Info table.
This all works fine, but I don't think it is the best way to do this. Also, doing it this way leaves the chance that the job might hang up and then the Database3's Member Info table will be empty.
I am trying to find if there is a more efficient way to do this. And any ideas are appreciated!!!
In idea i thought about trying is to populate the Database3's Member Info table, and then place triggers on Database1 and Database2's Member Info tables. If a row is created/updated/deleted in Database1 or Database2's Member info table, it could take that information and update the corresponding information in Database3's Member Info table. But I have never really messed with triggers, so this may not be possible.....
Another idea I though of is to run a job once a day, but then have a cursor that goes through each row in Database1 and Database2's Member Info table, and if the information is not found in Database3's Member Info table, it could then either create/update/ delete that info.
Just wanted some opinions/ideas before I tackle this.
Hope this wasn't too confusing...
And Thank you in advance!!!
Replication Data
Jan 29, 2007Hi all,
Where is the replication log will be stored.My replication is failed due to server down.I have setup as a transaction replication. I just want to know where that log will be availbale.
thanks
krishnakumar
Data Replication
Aug 31, 2007Hi,
What is the best way to do a two way data transfer between Sql server 2005 and sql server 2000. These data transfer should take place on triggers happening on either of these databases. Please help. Is there any tutorial online which addresses this.
Thank You
Balancing The Data ,Replication ?
Feb 28, 2005Hi,
I have two sets of data i.e two instances of SQL server in two different cities. Data entry happens at both the places.I need to balance the data in two servers i.e. I need to Synchronize the data.
Currently I am Exchanging the data between two sides and using a Buffer database to update the incremental infromation.(Running a SQL script).
I have GUID columns in my database. I am too new to replication.I wanted to know whether I can implement repliaction and what changes i need to make?(e.g. Replacing GUID columns with Identity columns).
Permanent connectivity between two databases is required or Replication can be performed whenever connected?
Best Regards
Rohit
AMOUNT OF DATA REPLICATION
Feb 10, 2007Hy im PCV
I want to know how to calculate the amount of data(in MB) that is transfered from 1 server trought another
Puplisher--->Subscriber, using a merge replication. I know that the amount of data depends on the number of the rows and the scale of the colums. I only want to know how to calculate that amount of data. I am using Sql server 2000, and a OS windows XP profesional, thank you
PCV
Data Replication Performance.
Jul 20, 2005I'm seearching for information regarding database replicationperformance. We need to compare the performance of replication for SQLServer and Oracle and it is urgent! Anyone who can describe theperformance bottlenecks for each database when performing replication,or can point me to a white paper or webpage.
View 1 Replies View RelatedEncrypting Data Across Replication
Feb 7, 2007We are looking at setting up peer-to-peer transactional replication between two databases. We have a customer requirement to encrypt the SSN in this database. I have configured replication successfully. I have also successfully encrypted the SSN using a symmetric key (with encryption by certificate). What I haven't done yet is set up encryption to work across a replication topology.
What steps would I have to follow in order to be able to encrypt the SSN on one server, replicate it to the subscriber, and then decrypt the SSN on the subscriber? For this scenario, is there a better way to handle encryption other than a symmetric key encrypted by a certificate?
Deleting Data After Replication.
Aug 8, 2007I am looking for an opinion on the best way to delete all data from a table after it has been replicated.
The simple use case would be:
Data is replicated from production server to archive server.
Data is deleted from production serverThanks in advance...
Data Loss In Replication
Dec 6, 2006hi,
Im using merge replication.I have created one publisher with dynamic filtering and i have creted two subscribers from it(pull subscription).It was working fine.but after sysnchronizing 2-3 times data from some tables went missing
can any one help me....
thanks and regards
Dhanya
Start Replication With Old Data
Jan 31, 20071. I want to create a (transactional) NEW Publication and a NEW Subscription, but the Suscriber contains data inside the tables (articles) at the beginning (data from another year). Is this possible? How?.
2. I have a transactional Publication a Subscription running correctly. For X, the data in the Suscriber is deleted. I want to send ALL the data from de Publication. Must I delete the publication an create again for do this? Is the only way that we found but we think that is possible reinitialize or something like this.