I have SQL Server 2000 and 2005 running on the same server. My current system is in SQL Server 2000 and the new system is in SQL Server 2005. My users will be using SQL Server 2000 for the most part, But for the part the processes that have been migrated to 2005, they will be using SQL Server 2005 as well. The database schema is different on both servers eventhough the data will be similar in most respects.
Is there is a way through which any data that is inserted/updated in SQL Server 2000 via content Management System/ manually/ via a batch job, the data is automatically populated in SQL Server 2005 tables or vice versa?
I have created and deployed my first report. It renders fine for me and the other database admin. When others attempt to view it, we get the error
Query execution failed for data set 'periods'. (rsErrorExecutingCommand), For more information about this error navigate to the report server on the local server machine, or enable remote errors
Initially, We created a local group on the machine that hosts both the database and webserver and added the individuals to that group. Then, within SRS Report manager, we added that group to the Browswer role of the report. The error message was slightly different, in that it couldn't even open the Datasource.
We then added an individual to the database as dbreader, and got the above message. It apprently is starting to render, and when it encounters the first query (dataset "periods", which populates a drop down list for a parameter), it chokes. BTW, the Periods dataset executes a stored procedure dbo.Period_List that has no parameters. It returns a list of reporting periods.
I could not figure out how to "enable remote errors" or find an error log on the server. The C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles Log files did not appear to record any errors.
I have a module in power builder with Sybase database as its backend. The other modules related to the same application are running on Delphi with SQL server as backend.
My requirement is to sync between the Sybase database and SQL server (2000) in order to update the SQL server with all the transactions ( online ) done in the Sybase database.
I have tried the Sync the data from sql server mobile (.SDF) to Sql server 2005 (.mdf).In push command, i am getting the error "Sql Server Everywhere encountered problems when opening the database". string rdaOleDbConnectString = @"Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=master;Data Source=PRASSANAPRASANNA;Password=master"; qlCeRemoteDataAccess rda = null; try { rda = new SqlCeRemoteDataAccess(); rda.LocalConnectionString = "Data Source=D:/DATABASE/test.sdf"; rda.InternetUrl = http://localhost/Dataset/sqlcesa30.dll; rda.Push("company", rdaOleDbConnectString, RdaBatchOption.BatchingOn); MessageBox.Show("Completed");
}
catch (SqlCeException)
{
}
finally
{
rda.Dispose();
}
please guide me any one ours guys to solve this problem .
I need to make a sync between 3 or more SQL Servers. We have 3 Small Business server with sql server 2000. In all the 3 locations, branch and headquarters we've the same databate data. For sync with 2 there's no problem. I need to make it with three and then at the end of the year with four. Can anyone help me?
Hi to every one. For two years i am syncing sucessfully sql server 2.0 datas to sql server 2000 now i want to upgrade to sql server 2005. I am using Visual Studio 2005 for developing. Can any one tell the best method available to sync the data from mobile device to sql server 2005.
Also i have os win2003 standard in which i have installed sql server 2005 Does win2003 support mobile device connections with sql ?
I am just beginning development of a new app and I need a little advice onthe best way to go about doing something.The app is a project management tool for a construction company. Users inthe field will need to do remote updates both receiving and submitting databack to the main office. I can't just make it a live web app because theusers will have to be able to work off line and sync data later (presumablywith a VPN connection).What is the best way to go about this? I planned on using MSDE 2000 w/Accessfront end. I will install MSDE on each laptop but what is the safest/mostreliable way to sync only that information which pertains to a specific useralong with other general information.Any books that helpful with this specific issue? Any one have reusablemodules/code they'd be willing to send me?TIA,--Jake
When I install the SQL Server 2005 SP2 on my vista laptop, I get the following message: SQL server setup failed to compile te Managed Object Format (MOF) file c:program filesmicrosoft SQL Server90sharedsqlmgmproviderxpsp2up.mof. To proceed, see "troubleshooting an installation of SQL Server 2005" or "how to: View SQL Server 2005...
I Created one database named login.sdf in sql Ce ,i created one table login having two fields (username and password).it is working well.I trying to synchronise these with SQL2000 using Active sync.it is not working ..And one more things ,i tried to connect the default pocket PC 2002 emulator with Active sync.it is also not working.can anybody give some solution for these problem
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??
I created a report via Rpt services wizard. I can execute the report via Start Debugging. I would like to deploy the report so that i can view it via http://
I need to call the report via external app & pass parameters. This is what i selected in wizard. Report server: http://za001b78ad82c4/ReportServer
Can anyone please assist or have an example on how to.
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 ....
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
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
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.
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.
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?
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)
My database was previously running on sql2000 with 2 gigs of RAM and 2 x 2.8ghz XEON processors, and was running pretty decently.
I've now upgraded to SQL2005, 8 gigs of RAM, and 1 Intel 5130 2ghz processor (supposed to be more CPU power than previously)
The problem is its now running very SLOW.
I have run a trace and I'm finding queries that used to take 50,000 reads are now taking 1.4 million reads (25x more) The system runs for a decent amount of time but then SLOWS down massively for awhile. I can't find any cause yet.
What could be causing this ? What steps can I take towards resolving this? I have ran Tara's isp_ALTER_INDEX to try and help, I'm not sure what else to do.
Hi,After a power outage (and UPS failure), my boss's SQL Server 2000 won'tstart (or crashes quickly or something). We don't have any backups, as it'sa test server. Is there a way to import the database files into a new SQLinstallation? By "installation," I mean either a re-installed SS, a secondinstallation on the same PC, or maybe even on another PC. In another words,given only the files sitting on the harddrive, is there a way to "import"the DBs in those files into SS?Sp_attach_db would probably be the answer, except it seems to requirerunning sp_detach_db...which I cannot do, as SS is not working.Thanks in advance,Jay
I have upsized some Access 2002 tables to Sql Server 2005 express. I put together a query and when I try to execute it, it tells me the MS Access is an earlier version prior to SQL server 2005 and it will not save the queries. When I try to run them anyway, I get the repeated message and the query never executes. I'm taking a T-SQL class and this is how the instructor. Is they a fix for SQL Server or Access to get around this or do I have to revert back to MDSE 2000?? Can MDSE 2000 and SQL Server be loaded onto the same machine (laptop)? Help!!!!! I am very new at this...
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.
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
I need some assistence here.I have two servers. One with MS SQL 2000 Standard edition and MSDE(MSdesktop 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 justbackup the entire databases files b/c they are large and I'mtransfering them over DSL.I was thinking transaction logging, but I'm not sure. Is there a easyway to do this?I don't know how to accomplish this task.PLEASE HELP.
I have the merge replication (Push)Â for SQL Server 2008.The right-click option for Start and Stop Synchronizing in subscriptions has been disabled. How can I stop the merge replication and start again ?
This error happened 1 week after I created the merge replication. The merge data cannot sync to subscriber and only solution I can use is drop and re-create the merge replication again but error would be re-occur a week later. The merge replication work fine before and start from middle on May 2015, but it keep happen right now.
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
I have set up a merge replication with 4 subscribers and a publisher on SS05 sp2 on 5 window servers. After running my application on the replication with big data for a while, the data in some of tables of subscriber are out of sync from the publisher. I tried to run sp_resyncmergesubscription to fix the problem according to http://doc.ddart.net/mssql/sql2000/html/replsql/replmon_9pwh.htm. The procedure run successfully. However, the problem is still exist.
Hi, I worked on a project in ASP.NET using SQL server 2000 as the back end. Its a conversion application that I rewrote in ASP.NET using C#. I need to import the old data in Access db into SQL server 2000 and I have very little knowledge about doing it. The data in not a direct one -one transformation. There are considerable changes to the Database design and data types. Any help and suggestions wud be really helpful. Also, any article links wud be great.
Have run about six downlowds and all fail with same problem. The installer seems to be missing a file. all other parts of Viz studio Exp install but NOT the sql server exp.
Am I the only one getting this ? and if so what is the problem?. All other Visual Dev Express parts have instald OK.
Run on XP home SP2. As I posted this I noticed the compiler time stamp is 4 days ahead of real time ???
From the install log:
Complete: ParseBootstrapOptionsAction at: 2006/9/22 15:34:19, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 123
We recently started to use SQL server 2005. Now I need someway to sync some tables between the SQL server and our existing MySql db. Any recommendations on tools who will allow me to do this?
I have a (quite big) sql server 2000 database. I'd like to replicate the whole DB onto a 2k5 server. Then disconnect that connection, to have an independent copy on the 2k5 machine. After I made some modifications on the data on that machine, I'd like to sync those databases to have the data on the sql server 2000 as well.
Is this possible in any way (tool or API available) or must I hand code it? At the moment I do this thing by exporting to *.sql files, and then importing, but the replication/sync method would be quite nice.
