I am doing data migration two database in MS SQL 2005. The records are more than 200000 nearly 300000. I need to query from source database using joins and insert 2 or 3 tables in destination databse. Which way is the best way to do so? I am trying to write a program with VB.NET. If you have sample,
View 1 RepliesIn my Live sql database ,I have to change the date value from (date, month ,year) to date. Now there is 100 records with the date as date,month ,year(3 Fields).iF I change directly to date Field all the datas in the 3 field of those 100 records will automaticly change to a default date and original dates will disappear.What should i do to migrate all my datas safely
View 2 RepliesI am migrating to win vista from xp, I have an half completed program in XP , so i wanted to know whether i would be able to continue its development in vista or not. and an another question, whether my program which will be developed on vista can run on xp and vice versa?
View 1 RepliesI have developed an application using .NET 4.0 Framework, now i want to migrate to .NET 3.5 Framework.
When i change the Framework in advance compile option and run the application it gives me the following error. how can i over come this....
I have made the dreaded (but forced) change from vb6 to .NET.
View 1 RepliesAny program written in Vb 6.0 Is there any free source code available to convert vb code to vb.net?
View 3 RepliesI'm going to convert VB6 code to vb.NET 2008. Please advise me What is the best way to convert the code. My VB6 system used following comp.
View 3 RepliesI am working on a VB to C#.Net migration project. Has anyone used a tool called CSharpener to convert VB.Net code to C#? What is your experience with this tool? How much code does this tool migrate & how much is the rework?
View 1 RepliesI got a chance to work in the migration project(VB to VB.NET).I was confusing in the RecordSet functionality.In our project we are taking the DataReader according to the scenario.But in the Looping cases like dsr.EOF.
Dim recordset As dao.RecordSet
If recordset .EOF Then
' ' msgbox "Please enter some number ", vbOKOnly, "Number Not Found"[code].....
How to convert this into VB.NET?Either we need to write If Not reader.Read or If reader.Read.
I'm working on a project trying to migrate data from MS Access to CRM(Sales force) online web services database. Have you any ideas how this process can be done? Also, if you know of any VBA or SQL code or online sites that can help me with coding this migration?
View 2 RepliesI migrate a vb application from MS Access to SQL Server 2008 using DAO Connectivity.[code]My question is this Is there any way to just change connection from mdb to SQL 2008 without changing in code..
View 9 RepliesI'm migrating VB code to VB.Net and I can not figure out why my files are not copying to there new folder. Here is the old VB code below:
Public Sub FileTransferDoneImage(ByVal FilePath As String)
OnlyFileName = GetFileName 'Get only filename
OnlyPath = GetPathOnly(FilePath) 'Getting only the path
[code]....
The message box shows the correct path/file, but the files are not copying?
I'm working on some legacy VB5/VB6 code and need to convert a ".bas" file to vb.net. i found several options
Compile the .bas file into a com dll and then reference and use it in my project. (For this I guess I would need vb5 or vb6 which I don't have at my disposal) Copy and paste the contents of the file in to a new module in vb.net and then try solving the errors one by one.The contents of the .bas file reference a particular dll. The .bas file has mostly declarations consts, types, sub's and functions.
What would be the most elegant way of redoing this in vb.net. Is it as simple as option 2.EDIT
I used VS2008 express and ran the code through the upgrade wizard it did the necessary conversion. and the .bas file was converted to .vb. I took that file and decided to rewrite other parts of the code, including some redoing of the converted .vb file. Other questions related to this one are here.
I have been tasked to convert out VB6 program to VB.NET. In my research online everyone seems to say I need to go through my code and get rid of any Variants I have. I have had pretty good luck so far, but I am having an issue in replacing this one.
[code]...
I am still pretty new to VB (either 6 or .net) and I am having a hard time finding an alternative for this. Will the convert tool in VB.net handle this just fine? Or do I need to change this? If I do, is there a better alternative for this? Forgive my noobness.
As I wanted to benefit from new multicore threading improvements from .Net Framework 4, I recompiled all of my solution projects from 3.5 to 4.Everything compiled Ok. But what was my surprise to see that my application runs much slower when compiled in .Net 4 compared to 3.5. I was not expecting that at all. It is a scientific processing App, so computing time is what it's all about. I have no clue where to start from, and for the time being, and I prefer to think that I have missed something during the migration process, that is fixable, rather than the App is "per se" running slower in .4 (can't see any logical reason for that...)
View 2 RepliesI have come to know that there is a code migration wizard, that heps migrate from vb6 to vb.net.
View 1 RepliesI'm migrating the CenterSnap.cls from its vb version to vb.NET and I'm confused about the following 2 errors after I import the vb6 project to VS 2008.
[Code]...
I have a application VB.net which is working fine for office 2003.But one of the user has installed office 2007.I dont have the knowledge of BindingRedirect .
Old references
Interop.Access version 11.0
VBE.Interop version 11.0[code]....
Our company's current system test cycle involves the use of word documents for the UI test scripts and test execution log.For each new release, these documents are copied from the previous release and then modified to reflect the current release version together with new test steps where there are changes in functionality.Firstly, this is time-consuming - editing each word document (around 150 docs) just to make minor changes. Secondly, mistakes may occur as this process is manual.If I were able to port the test scripts into some data store (eg. sql server, xml file), would it be relatively straightforward to generate the word (or rtf, but not pdf) documents (using a word template with custom fields perhaps) based on this data set.
View 2 RepliesI got all C# implementations on Google, so I converted it to VB.Net, but I am not able to convert 1 line where it gives error.My Class :
Imports Migrator.Framework[Migration(1)] ' Gives ERROR Here.. How to write this in VB.net ?
Public Class mig_001
Inherits Migration
Public Overrides Sub Up()
Database.AddTable("Planets",
New Column("Id", DbType.Int32, ColumnProperty.PrimaryKeyWithIdentity),
[Code]...
I have a VB6 application which i need to convert to VB.NET 3.5. The application uses a lot of Business objects libraries and some external libraries.I would like to know if these libraries would behave the same way when i move from VB to VB.net?Are there chances that things would break?
View 1 Replieshow to enumerate the used file-numbers [as in FileOpen(filenum, ...)] in Visual Basic .NET 3.5 (VS2008)?
The situation is: I'm doing "a quick port" (just to bring it up a supported architecture) of an old VB6 WinForms application (it's "just a tool" really, not a full-on app) to VB.NET using Visual Studio 2008's automatic translator, over the .NET 3.5 framework. The existing code stores "records" in parallel arrays, the index of which is the output-file-number, and output-files are opened and closed "ad hoc"... so I can't "just" use FreeFile (I could, but it'd basically be a rewrite, which we won't get paid for).
After translating I've got an "invalid filename or number" error upon FileOpen'ing filenum=350 for Ouput... I know the filename is valid, and doesn't already exist. I tried (just for debugging) setting filenum=FreeFile and that worked (i.e. the file was opened)... so I figure that filenum=350 is already open, but how to tell BY WHAT? A listing of the used filenums -> names would give a huge leg-up.I suspect this just isn't possible, but I've got to ask anyway, because it was save ever-so-much time, effort, and thought if it is possible, so here we are.
How i can select a single cell from selected row in datagridView and after selecting that i want to put simple search functionality(like we have in our windows folders-typing any characters and search should work)
View 2 RepliesI am attempting to migrate from vb6 to vb2k8. My first attempt is a program with three forms. The first form extracts data from Oracle into a local Access DB. It works great but the second form only pulls data from Access to generate a text file. The VB6 version does it in 10 minutes, the VB2k8 version gets 1/10th through the data in two hours. It is hanging on:
"select sum(hrs) as thrs from tablename where emp_id_no='xxxxxx' and hours_type='CE' and org_ofc_sym='oos'"
I have to hide identifying fields but the emp_id_no and oos are correct.
I have a finished a software written in ruby on rails. It is possible to convert it to visual basic?
View 3 RepliesI have a thumbnail generation routine that I created using WIC for a .NET app. It has been working fine for the past year, but we just migrated to a new server.
[Code]...
I have checked and the picture data is valid data. The exact same picture works fine if I run the code on the old server.
Update2 my answer to my question. Update I updated the code per @Eddy comment below, however I'm still getting an error on the myRange = Globals.Sheet...line.
Dim xlDown, i As Int32
Dim myRange As Excel.Range
myRange = Globals.Sheet1.Application.Transpose(
Globals.Sheet1.Range(
[Code]...
Over the past few months weve been running a pilot in these forums allowing you to submit bugs and suggestions to us directly. Weve learned a lot during this pilot and were enthusiastic about, and committed to, expanding our ability to take your feedback, and respond to it thoughtfully. By now you've hopefully seen our announcement about our plans to migrate these forums to our brand new forums platform. As a part of this migration were going to be closing down the bug and suggestion pilot program. Were going to take some time to analyze how well the pilot went, see what we need to tune up, and make sure that we build the right features into the new platform.
[Code]...
I am upgrading user control from vb6 to vb.net.In the vb6 application I am loading 3000 labels using a label control array.In vb.net I am doing same but it's taking too much time to load.In vb6 it's taking 1-2 seconds, but in vb.net it's taking 30-40 seconds for same work. Why does it take too much time in vb.net for same work?Code is given below, here Led is the label control array.
For l = 1 To 3000
Led.Load(ledCounter)
ColLed.Add(Led(ledCounter))
[code]....
I am work on VB.net 2003 Framework 1.1 for last 3.5 years in windows Application.We are currently migrating to VB.net 2008 framework 3.5, but i don't know about the features which related to ADO.net and which is important to performance. I know linq to SQL but our architecture is made in .net 2003 so we should follow this.Any features which is very important to enhance the performance?
View 2 Replies