C# - Sync Production And Testing Databases
Nov 5, 2010
I need to sync the data of a ms-sql 2005 & 2008 server to my development server (mssql 2005 & 2008). The problem is I can't create .bak files, no permissions (to access the network share where the backup is saved). The problem is not that I may not view the data (I have complete read access to the production server). I can also backup data to csv files and read them in on my system, but that's rather painful (encoding, foreign key reference constraints, having to do it for every table, etc...). The problem is that the admin has no time to set me the necessary permissions (he has larger problems...).
How can I still sync the data to my development server ? I need some kind of syncing to a file, then transport anyhow (manual by FTP if necessary), and then update my development database. I've already tried backing up to a back file on a network share, but that doesn't work either. I don't mind if I have to code a bit in my free time, but I really don't want to do all the low level stuff myself, like resolving constraint dependencies.
[Code]...
View 6 Replies
ADVERTISEMENT
Feb 23, 2010
I have a client that has the basic database on a server(sql server 2005 express database) and wants to work on his laptop from his home, so i guess that i can install the software on his laptop but how will the 2 databases be synchronized, having same data. the synchronization will be made once a day in the morning when he returns to his office. How can this be accomplished?
View 2 Replies
May 15, 2009
I'm looking into adding some unit tests for some classes in my data access layer and I'm looking at an update routine that has no return value.It simply updates a row based on the id you provide at whichever column name you provide.Inside of this method, we collect the parameters and pass them to a helper routine which calls the stored procedure to update the table.Is there a recommended approach for how to do unit testing in such a scenario?
View 4 Replies
Aug 25, 2009
I use VS team system 2008. At the moment i need to test some business classes, i have found two kinds testing NUnit and the unit testing provided by the VS team system. what are there differences?
View 1 Replies
May 13, 2010
I'm building an Active Directory wrapper in VBNET 2.0 (can't use later .NET) in which I have the following:
IUtilisateur
IGroupe
IUniteOrganisation
These interfaces are implemented in internal classes (Friend in VBNET), so that I want to implement a façade in order to instiate each of the interfaces with their internal classes. This will allow the architecture a better flexibility, etc.Now, I want to test these classes (Utilisateur, Groupe, UniteOrganisation) in a different project within the same solution. However, these classes are internal. I would like to be able to instantiate them without going through my façade, but only for these tests, nothing more.
[Code]...
View 1 Replies
Nov 11, 2010
My technique for deploying an ASP.NET webapp into production is as follows[code]...
I don't stop the database or run any additional tools to promote to production. It's a small company, and this seems fine. What's wrong with this technique in your opinion?
View 4 Replies
Jun 4, 2010
Currently all my application that is released is always release in production. However I would like that changed and also have a development side (For testing).
I've tried searching for steps on how to create a development server however I cannot seem to find a tutorial.
In the past I've seen someone release their application in development by having it in on "Debug" option and have it released in production by having it on the "release" option. (I apologize for the vagueness as it was along time ago since I saw it).
View 2 Replies
Oct 26, 2011
I'm working on a "UPLOAD DOCUMENTS" functionality where different customer can upload the required documents and employer should be able to view all the uploaded documents by the customers. Currently in my local system I can upload the documents and it saves the uploaded file to "inetpub" folder. But in order to provide "upload documents" feature to production environment what should be the path?
View 1 Replies
Jun 17, 2009
From my initial readings on unit testing it is wise to put all of your setups and tests in a separate project from the code being tested.I've recently begun reading The Art of Unit Testing, trying to discover how to break dependencies on things such as database calls.The methods offered involve changing areas of the test code, such as adding specific interfaces and "stub" methods to the production code.This seems to defeat some of the good things about keeping tests and production code separate.Is there any recommended dependency-breaking technique that doesn't involve changing production code?
View 3 Replies
Sep 21, 2010
I do have an application distributed with click once. I want this application to be installed (and thus distributed) two times on the same computers. One time as production version and one time as deployment version. When trying to do so, I get the folloging error:
"Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application."How do I modify the manifest version in a way that allows my easily to switch between "Production" and "Testing"-Version?
View 2 Replies
Dec 22, 2010
My MSSQL 2008 and VS2005 were corrupted out of sudden. I had reinstalled .net Framework 2.0, .net Framework 2 SP2, MSSQL 2008 and VS2005.
After installation and without any code modification, I tried to debug the program and I got the below error message.An unhandled exception of type 'System.TypeInitializationException' occured in Production.exe.Additional information: The type initializer for 'Common' threw an exception.
View 1 Replies
Jun 3, 2009
I have an application that contains both test code and production code. The test code points to the test files on the local machine while production is located on the server. I comment out the production code when testing. To save some time I figured I would create a Global Variable integer called pTest and encase the test and production code in a Case statement so that if I set pTest=1 then the test code will run and if pTest=0 then production code will run.
[code]...
View 6 Replies
Apr 30, 2012
I currently have my resources (images) in C:inetpubwwwrootimages I also have the images in the same location on my production server. How can I set it up so that I don't have to constantly sync up the folders? Seems like an easy thing but I'm not sure..
View 3 Replies
Jan 21, 2011
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code].....
View 2 Replies
Nov 10, 2009
I have a windows application and a php web application(not connected to internet all times), eventually data add/remove/update can happen at either places. So data has to be synchronized every day or manually.
I have a small sqllite database file (less than 500K) in my end, and the php web app uses Mysql, the structures remain the same. I would like to have a update function in my windows app, which sends my sqllite database file directly to my webserver and then1. Php should read values from the sqllite database files insert some values into mysql from the uploaded file 2. Php should read values from the mysql database files and insert them to sqllite database file
and finally send them back to my windows client pc. I would like to use .net 2.0.Anyone has an idea to get the above done or a suggestion to make the sync easier will help me a lot. Give me light on how the architecture or design should be done to achieve this
View 1 Replies
May 30, 2012
I have a class that sends an email which i use sendasyc
SMTPServer.SendAsync(message, _message_id)
The result of the email is captured by the following code
Sub SendCompletedCallback(ByVal sender As Object, ByVal e As AsyncCompletedEventArgs)
Dim message_id As String = CType(e.UserState, String)
[Code]....
This works fine when the code is run within a form but when i move it into a dll calling it from a console app it neither sends emails nor picks up any errors.
View 2 Replies
Oct 22, 2009
Public Class Form1
Public elapsed_time As TimeSpan
Public start_time, stop_time As DateTime
Public txtBreak As String = "180"
[code]....
All the code needs to be controled by seperate timers as the user may need to pause timer3 or timer4 at any one time. The problem I have is that after about 5 minutes the time and elapsed time are about three seconds ahead of the two count down timers.
View 8 Replies
Oct 28, 2010
I work for a shop that maintains a fairly new app. The app still has its fair share of bugs, with numerous tickets coming in daily. The error information we're given with those tickets is not as useful as it might be because the application was compiled in Release mode, which I read is smaller and faster (makes sense).
Are there any ramifications to deploying a .NET application to production that was compiled in Debug mode? I would expect it would be a bit slower, but I've read the difference is nominal. This would assure us that when we get errors on tickets we have line number associated with those errors and this, of course, makes debugging much easier. major red flags that would prevent you from doing this? I'm tasked with researching the possibility.
View 6 Replies
May 18, 2012
I'm being asked to maintain several internal-only web apps for my company. For testing, after making my changes, I've created some staging sites which make use of separate databases. As such, if my users were to mistakenly use this site as if it were the production site, they may enter important data and wonder where it "disappeared" to thinking it was the production server.
I'd like to create a big banner of some sort across the top of the staging site (which ONLY appears on the staging site) to remind my users that they are on the test site. I'd like recommendations on the best way to do this, with the following considerations:
IDE: Visual Studio 2008
Server: Windows 2003 with IIS 6
Language: VB.NET 2.0
View 2 Replies
Jan 22, 2011
I m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
[code]..... ...
View 2 Replies
Jun 2, 2011
I'm just looking for an answer or idea.I plan to connect vb.net to mysql (which is done) and also the PHP connected to the mysql.But I'm confuse with something.VB.NET is use for offline things (which people will come to store and buy), but PHP is buying / booking online. (You know the airport things right ? customer can directly go to the airport and buy tickets or they can buy tickets from the internet)
For ex :Customer A come to airport and buy a ticket which is only left 1 tickets. Customer B wanted to buy from the internet. Both of them saw there is only left 1 tickets. So, both of them buying. When Customer A buy, the employee click buy at the same time with Customer B.In here, I'm confuse, how to declare which person should get the ticket because they click buy at the same time (server time because PHP and MySQL located to the server and vb.net applciation located to other PC/Machine) ?.
View 1 Replies
May 1, 2010
I have two comboboxes on my form and both are bound to the same datatable. The problem is that each time a value is selected from one combobox, the value in the other combobox changes to the value selected in the former. Is there anyway to disable this behaviour?Only performance counts!
View 2 Replies
Aug 18, 2010
On my form I have a button that says "Sync To USB" When its clicked this is what I want to happen: The files in ListBox3 will be copied onto a USB Mass Storage Device (if it is inserted) otherwise it will play the sound "USB not inserted.WMV".
View 5 Replies
Sep 24, 2010
i just want to ask if how can i sync my files (like dropbox) via web service? is that possible in vb.net?
View 2 Replies
Mar 11, 2009
How can I sync 2 binding sources, both binding sources contain the same data(contactsbindingsource)I have 2 forms:1 form is a list of contact information the other is a search form.I have a linq querie in the search form that returns contact names to a datagridview, but I want to be able to double click on selected cell and have the relevant data appear on my first form.Also my first form has FK relationship to another form that contains company information, could this have something to do with it?
View 6 Replies
Mar 3, 2009
I am reading a lot in this forum about sync. It must be fantastic. I look a round for any tutorial, but I haven't found one. Let me tell me the story about the new program I want to write.I am working on a campsite in France. When there is a problem like a Mobilehome isn't clean. The person who is working on the reception write a note and the one how is going to fix it will be called. This is not a really good thing.I like to write an program in Visual Basic that allow the person who is working at the reception write the task in an program. This program will use a database to store the task. The person who is working at the campsite will see the task at his mobile phone (Windows mobile 6) He will fix the task and the reception can see in the application that the task is done.So I need a database who is synchronized whit the one in the mobile phone. The mobile phone can work offline and online. By online the database will be synchronized to the one in the reception.
View 1 Replies
Sep 13, 2010
I have a small "Clinic Application" that runs on two machines. (Receptionists & Doctors)
Same application is installed at both the computers, and they access the same SQL Server 2008 Data at a 3rd macine.
When the application is started, the local datasets are filled with the data from the 3rd machine (using tableadapter.fill).
Whenever the Receptionist adds a Patient in DataGrid,and saved it, it should show in Doctors DataGrid. and whenever Doctor adds something, the receptionists dataGrid should show it.
to accomplish this I have set a timer that keeps Filling datasets.
the task is successfully accomplished, but....
View 12 Replies
Jul 18, 2010
I have a new requirement to sync a DVR to an NTP server, but not sure how. I have googled and forum searched, but a lot is VB6 stuff and also for sync'ing a local computer's time. This requirement is for sync'ing time for a Digital Video Recorder on the network.
View 10 Replies
Oct 25, 2011
I have been using vb.net for a while. I am trying to figure out if there is a way that i can update file in a given folder to ftp and get any file on server back using vb.net?
View 2 Replies
Jan 7, 2012
i'm interested in syncing a remote folder and a local one over FTP but I don't want to use 3rd party components since this is not going to be a public build so I see no reason to invest on something like this now any code snippets or so available? PS. remote folder includes folders also that can change so I want to keep an update of the remote folder on my PC.
View 3 Replies
