Sync To Databases Nightly With BLOB Data
Dec 10, 2005
I need some assistence here.
I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS
desktop engine).
I need to sync my databases nightly, as a backup.
Is there a cheap software that will do this? I don't want to just
backup the entire databases files b/c they are large and I'm
transfering them over DSL.
I was thinking transaction logging, but I'm not sure. Is there a easy
way to do this?
I don't know how to accomplish this task.
PLEASE HELP.
View 9 Replies
ADVERTISEMENT
Sep 13, 2007
How would you solve this problem?
Would you use replication? SSIS? Schedule stored procs? A third party data tool?
We have about 50 databases located at offices around the world. There are several key tables which we need a central copy of at our Head Office.
We need only the new INSERTS or UPDATES for the day to be copied to head office.
The copying process should happen after business hours for that office.
Some cleaning of the data needs to happen before updating head office.
Our database is being installed at new offices every other month, so it's important to us that this be easy to add a new database into the schedule, ideally without needing a SQL DBA or Developer.
We want something robust, performant and easy to troubleshoot.
Kev
View 1 Replies
View Related
Jul 20, 2005
Hello,I've got 2 databases (both on MS-SQL Sever2k). One of them (remote)contains table which is often updated. For various reasons I'd like tomaintain a copy on local MSSQLServer. Is there any built-in mechanism whichallows to do such things?! I can do this manually, by examining the remotetable contents, and downloading new stuff (local table cannot be modified inany other way), but I guess that there is a smarter way. Any ideas?!ThanksPiotrek
View 1 Replies
View Related
May 25, 2007
Hi,
If I have 2 mobile databases, 1 on my desktop and the other on a PDA, how do i synchronize both these database? Are there any vb samples where i can refer to?
thanx
View 4 Replies
View Related
Aug 31, 2012
Currently our client has a website where they are using aspx as front end and SQL server as back end. We are developing same functionality using php and my sql.Currently 1 phase of development is finished. They are using both applications to do the job. Now in 2nd integration they are asking the data sync from one database to other.
We have decided once the user enters the aspx form the data will be stored in client sql server but we though of writing a script to enter this info into a csv file so that from our side we access that file and update in mysql.
Other than ftp any other better approaches to access that file on client server?Is there any possibility to sync databases directly?
View 4 Replies
View Related
Jun 23, 2007
Hi, I have compact sql databases which will be local on multiple users
devices. Due to space constraints, for one of the tables i have had to use
auto incrementing integer which works fine for the local database but i
would like to merge all of the users databases into a global database. The
table format can be seen below:
Code SnippetCREATE TABLE Players
(
ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY,
FirstName NVARCHAR(32),
LastName NVARCHAR(32)
);
CREATE TABLE Sessions
(
ID INTEGER NOT NULL IDENTITY,
PlayerID UNIQUEIDENTIFIER ,
SessionDateTime DATETIME,
CONSTRAINT pkSessions PRIMARY KEY (ID),
CONSTRAINT fkPlayerID FOREIGN KEY (PlayerID) REFERENCES Players(ID)
);
CREATE TABLE SessionDetail
(
SessionID INTEGER,
Time real,
Power real,
CONSTRAINT pkSessionDetail PRIMARY KEY (SessionID,StrokeTime),
CONSTRAINT fkSessionID FOREIGN KEY (SessionID) REFERENCES Sessions(ID)
);
The Players table will merge fine as GUIDs are used. However, how will the
sync capabilities of compact SQL handle the sessions table? When it pushes
the local data to the remote database will it change the Sessions.ID column
to a unique field (as no doubt lots of people will have 1, 2, 3 in their
local databases and the global database must have a unique ID), and then
transfer this changed ID back to the local database? Furthermore, if it
changes the Sessions.ID column during the merge it will also need to update
the SessionDetail.SessionID foreign key to maintain referential integrity,
is this also handled?
So my question is, how much of this sync and data merge is automated and are
there any good examples or pointers for my scenario? I cannot reasonably use
a GUID for Session.ID as there will be lots of SessionDetail entries and the
size would be far too much.
Many thanks,
Chris
View 7 Replies
View Related
Aug 2, 2005
Can someone please show me an example on how to read & write blob data to a Database? For example if I have the query below (Northwind), how do I actually place the blob item in a picture box on a windows form?SELECT Picture FROM CategoriesWHERE CategoryID = 5
View 2 Replies
View Related
Aug 2, 2005
Can someone please give me an example in C# on how to retrieve an Image from a Table and store i into a Picture box on a windows form? In addition, how to insert a blob record into a table as well.
View 4 Replies
View Related
Feb 24, 2004
Does anyone have any experience of this type of data please? I have been asked to work on a project where it looks like we will be taking MS Office files and scanned images and storing them in a SQL 2000 db so that they can be aquired by a third party application. I am most intereested in the size of the records as the server may need upgrading, for space and performance.
I am also interested in how a BLOB record is created, is it a particular save process from Word / Excel etc or can you specify to import as a BLOB from a SQL script?
Any info welcomed as i really dont know where to start !!!
TIA
View 5 Replies
View Related
Jul 23, 2005
Hi all,It was my understanding (Please correct me if I'm wrong on this!) thatBLOB data actually reside on their own separate pages and a BLOB fieldonly holds a pointer to the location of the actual data, therefore theBLOB data per se would not get written to the log, only the pointerwould be written.If log shipping works by applying the transaction log to the standbydatabase, then what happens to the BLOB data?Related question, how does transactional replication work? Is it alsobased on the transaction log?TIA,Ellen
View 4 Replies
View Related
Dec 18, 2007
Hi, I have to migrate an oracle database over to SQL Server 2005. One of the tables has PDF files stored as BLOB. All the ORACLE providers in SSIS do not support BLOB column. What can I use or how can I get the PDF files into my SQL table? The SQL column can be either IMAGE or VARBINARY(MAX).
Thanks,
Les
View 8 Replies
View Related
Apr 7, 2007
hi,
i learned that BLOB data types are out-row data by default, i think it means it will not store in the row of table, because the max-length of a col is 8KB.
but will the system store those BLOB data? and is there any way to specify where should it be stored, like tha Partition Schema.
i am using SQL Express, so i hope it works for express.(partition does not work for express)
View 5 Replies
View Related
May 26, 2000
1. How many blob data types can be defined in a table on SQL Server 7.0
2. What is the max size for a blob data type.
View 1 Replies
View Related
Oct 9, 2007
Hi,
I have a problem with writing BLOB data into type of 'image' field.
If the data size > ~280 MByte (< 2 GB) the operation failed.
It is appear on SQL Server 2000 and 2005 (MSDE and express also).
Detailes :
column type : image
Server : SQL Server 2005, version - 9.0.3042
technology : OLEDB, from C++ -> CDynamicAccessor
protocol for communication : TCP/IP
Size of the DB : ~3 MByte.
As I see the provider read partially (~267 943 936 byte if all is 280 MB) of data from my ISequentialStream.
Error of OLEDB:
DB_E_ERRORSOCCURED : 0x80040e21
[DBNETLIB][ConnectionWrite(send()).]
General network error.
SQL Server error log entries :
10/05/2007 16:52:53,Server,Unknown,A fatal error occurred while reading the
input stream from the network. The session will be terminated.
10/05/2007 16:52:53,Server,Unknown,Error: 4014<c/> Severity: 20<c/> State: 1.
Entries of SQL profiler :
Error: 4002, Severity: 16, State: 4
The incoming tabular data stream (TDS) protocol stream is incorrect. The stream ended unexpectedly.
I used to set up the bug with contents of a ~350 MB .zip or .mdf file. Everyting is ok when the data <= ~250 MB.
I had ran MS Network Monitor on the server side and not found partially transmitted frames (but I use it on first time).
We try it on another machines, on another LAN with other BLOB (and the bug arised).
I had try 'named pipes' protocol for communication (and the bug arised).
I will be glad if somebody maintain that how can I found the origin of the bug (tools, log options, protokol settings etc.) or
I can present my simple test program (VC 2005 project) and its database (MS SQL 2005).
Best Regards,
Imre
View 4 Replies
View Related
Aug 25, 2006
How do I use the GetBlobdata to get the string representation?
I have tried numerous version of Encoders thinking that
System.Text.Encoding.GetEncoding(Row.TextData.ColumnInfo.CodePage).GetString(b) (where b is the byte array returned by GetBlobData)
But this doesn't work. I have had to resort to converting the field in SQL, so I don't have to deal with blobdata.
View 4 Replies
View Related
Nov 28, 2006
Hi all,
I am trying to store binary datafiles into a SQl Express table. However I can not find the BLOB data type when I am designing the table. Are we limited to using that kind of data type in the Express edition? Thanks.
Ke
View 1 Replies
View Related
Apr 2, 2007
Hi,Can we insert BLOB data using store procedure using Oracle and ASP.Net.I have inserted BLOB data using insert command, now i want to insert that BLOB via store procedure....any links/tips will be helpful...
View 1 Replies
View Related
Oct 21, 2005
Hi experts,
I have a textbox and a upload file function in my asp.net page.User can either copy/paste their resume in text or upload their resume file and submit the application.The uploaded file will be saved into a BLOB column, but do you know if text in textbox can be saved into BLOB column?
I received error message on the code:'save Applicant resume to a BLOB-image datatype column objComd.Parameters.Add(New SqlParameter("@AppResume", SqlDbType.NText))
error:Exception has been thrown by the target of an invocation.Operand type clash:ntext is incompatible with image
View 1 Replies
View Related
Sep 11, 2006
Hello,
I have SQL Server 2000 and I'm trying to import data from a paradox v5 database. Everything has moved over fine but the data from the blob fields. When I use the import tool and try connect to a paradox blob field, the import wizard does not "see" the paradox blob field. here is and example.
If I have a table with the following fields.
id char(20)
description char(120)
image blob
the ms-sql import wizard sees
id char(20)
description char(20)
I find this very odd, but I do need a solution. Any Ideas?
TY
View 3 Replies
View Related
Jun 10, 2014
How to access the XML, CLOB and BLOB Oracle data through linked server from SQL Server 2012?
I want to retrieve XML, CLOB and BLOB data from SQL Server 2012 through Oracle Linked server .
View 1 Replies
View Related
Feb 11, 2008
I have two databases data1(Express 2005) and data2( Enterprise 2005). Data1 is a subset of Data2. Now beginning from that state any changes to either database should be reflected on both of them.
Now what's my best solution to accomplish this considering one is the subset of other??
Thanks
View 3 Replies
View Related
Jul 11, 2005
I am using SqlServer 2000 and Jdbc connectivity in my application on windows.So, when i execute a query on Sqlserver database as :
Select * from DBO.RS_TABLELOB where Rep_sync_id > 15 and Rep_server_name != 'replicator' order by Rep_sync_id;
This problem is only with the BLOB data types in table RS_TABLELOB.
Then i got an error as:
[Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column
1.'.'.at com.microsoft.jdbc.base.BaseExceptions.createExcep tion(Unknown Source)at
com.microsoft.jdbc.base.BaseExceptions.getExceptio n(Unknown Source)at
com.microsoft.jdbc.base.BaseResultSet.validateColu mnIndex(Unknown Source)at
com.microsoft.jdbc.base.BaseResultSet.getObject(Un known Source)at
com.microsoft.jdbc.base.BaseResultSet.getObject(Un known Source)
Please help me out, if you have any idea!!!
Thanks in advance
John Berry
View 1 Replies
View Related
Apr 13, 2006
I need to keep the data in my development server and production server in sync.....What is the best way to do this?Remember for example development data may have some addition columns in a table which may not exist in production.....Pls let me know how can i achieve this.
I cannot apply backups because i will loose the ongoing development ....
View 2 Replies
View Related
Jul 23, 2005
Hi,We are going to be running two SQL Server 2000's from the samephysical server, with Windows Server 2003, and I need to have certaintables between them syncronized. Database A is a backend to a website anddatabase B is going to be used by a different department. Both thedatabases have certain data in common but it isn't stored in the sameformat. I can't just auto sync one with the other, the data (records) hasto be manipulated before updates between them can take place.So, what I need to do is convert certain data when A is updated and tranferthat to B and vice-versa, in real-time. I've looked at Snapshot, thatisn't an option. I imagine some kind of Event Driven API is needed, wheredo i being?TIA
View 4 Replies
View Related
Jul 20, 2005
Ok..here is my problem. I have two SQL servers that I need to haveidentical, at least semi-real time data on. One is in a public DMZwith full access to and from the internet, and one is behind acorporate firewall and the box can get out to the internet but cannotbe hit directly from the internet in. The two are on seperatenetworks and cannot be connected via lan. Is there a way for me tohave semi-real time data transfers between the two to keep bothservers identical? I have thought that the server behind the firewallcould initiate an XML session with my dmz sql server and processupdates, but I am unfamiliar with how it would know what has changedon the remote server and how the remote server would know what haschanged on the server behind the corporate firewall. Any good ideas?ThanksDan Hirsch
View 3 Replies
View Related
Mar 24, 2008
I'm working on an application that will be running on two or more machines. Each machine is logging data to a local SQL Compact database. I would like to make these two computers sync the data with eachother, but I am unsure what the best method is to transfer data between machines in a table format. I think XML would work well, but there may be something easier, so I thought I'd ask. Do I want to use sockets to do this, or is there another type of connection that would work better?
All PCs will know the IP addresses of their peers. I forsee each PC having a server thread that is listening all the time. Each PC also has a client that checks to see if it can connect to the server on the other side. It then requests certain data, which the server part sends. Does this sound right?
The rest of the app is in Visual Basic 2008 Express.
Thanks,
Lance
View 16 Replies
View Related
Dec 23, 2004
I have 3 SQL databases: A, B and C. A and B are branch databases while C is the central (HQ) database. A & B will be constantly updated while C will updated occasionally and usually will be used for reporting/data browsing. Even though A & B are from different branch, they do have share some data records.
Every day, I will have to sync A & B's new/updated data to C and C to A/B. I know I can use Replication but I can't. You see, A & B are located in our own branch server while C was hosted on a third-party server. The webserver provider for C would not allow me to do any Replication on C.
What other alternatives that I can use to synchronise all 3?
DTS? XML transfer? It looks as if I have no choice but to write my own sync scripts? :((
Anyone has encountered similar situations? Any recommended SQL Tool programs?
Please help. I'm at a loss of what Im going to do.
View 1 Replies
View Related
Mar 28, 2008
thanks 4 ur rpl..well i have a simple doubt if u can guide me it will b gr8 help..well i am developing an application of location based services, in which i am going to store my data on SQLserver 2005 and will fetch the data from it when the user logs in to the user's PDA device so that a user can work offline on the data when there is no connection and when he gets the connection he can synchronize the data with SQLserver 2005. so now i m confuse whether i should use the merge replication or ado.net synchronization framework or RDA?what is the difference between merge replication and synchronization and which is better?
View 1 Replies
View Related
Sep 28, 2006
Dear All
Iam receiving an error message when trying to complete the subscription. Please find the below given error report that I get from SQL server.
Synchronizing Data (100%) (Error)
Messages
· A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)
The schema script '\MAINsnapshotuncMAIN_SQLMOBILE_TEST20060926133385MembershipData_2.sch' could not be propagated to the subscriber.
HRESULT 0x800704CF (0)
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)
The operation could not be completed.
View 6 Replies
View Related
Oct 9, 2006
Hi Darren & All,
Thanks! As per your guidance, i have tried in the pull method.Now i am getting error "The LocalTablename parameter is already specified".
Coding as follows:
string rdaOleDbConnectString = @"Provider=SQLOLEDB; Data Source=PRASSANAPRASANA;Initial Catalog=master;User Id=sa;Password=master";
SqlCeRemoteDataAccess rda = null;
try
{
rda = new SqlCeRemoteDataAccess();
rda.LocalConnectionString = "Data Source=E:\SampleTest.sdf";
rda.InternetUrl = "http://192.168.1.118/TEst/sqlcesa30.dll";
rda.InternetLogin = "IUSR_PRASSANA";
rda.InternetPassword = "PRASSANA";
rda.Pull("company", "Select * from company", rdaOleDbConnectString, RdaTrackOption.TrackingOn);
MessageBox.Show("Pull Method");
}
catch (SqlCeException)
{
Message.show(ex.message);
}
finally
{
// Dispose of the RDA Object
//
rda.Dispose();
}
}
Please guide me in detail, what mistake i have done in this method.
Thanks ,
Prasanna.
View 1 Replies
View Related
Apr 5, 2008
Hi! I tried to save some image data, but it get truncated at 8000 (the table column is defined as Image). I then wrote a converter to try ntext-datatype instead, but it gets truncated at 4000.
Error message:
System.Data.SqlServerCe: @3 : String truncation: max=4000, len=4168
The code uses only ADO entity framework for database access. Is there a way to store binary data larger than 8000 bytes? I am running SQL Compact 3.5 sp 1 BETA.
Henning
View 7 Replies
View Related
Mar 30, 2004
hello everyone,
i am developing a application using C#and .NEt compact framework.
for that i need to sync pda data (in xml format) with the remote database server(SQL) and vice versa.
please help me out
thanks in advance.
View 5 Replies
View Related
Jul 21, 2014
I've stepped into a new environment and have never dealt with multiple data files on user databases only with Temp db.What would be the best way to get all my data files in sync. I have done this on databases that aren't that big in size or off in size by a lot. Here is what I have
Mdf -- 69 GB
ndf -- 3
ndf -- 3
ndf -- 3
ndf -- 3
ndf -- 4
ndf --4
ndf -- 2
View 7 Replies
View Related