Yes, I know. The existence of a running copy of SQL Server 6.5 in 2008 is absurd. That stipulated, what is the best way to migrate from 6.5 to 2005? Is there any direct path? Most of the documentation I've found deals with upgrading 6.5 to 7. Should I forget about the native SQL Server upgrade utilities, script out all of the object...
What are the best methods for tracking and/or automating DB schema changes? Our team uses Subversion for version control and we've been able to automate some of our tasks this way (pushing builds up to a staging server, deploying tested code to a production server) but we're still doing database updates manually. I would like to find o...
What are some good steps to follow for a smooth migration from PHP4 to PHP5. What are some types of code that are likely to break?...
There are a number of migration libraries for .NET. Which one do you prefer and why? For those of you who haven't heard of migrations. This is something that Ruby on Rails made popular. It is a way to specify your database schema and version in code, and easily "migrate" between versions of your database. Here is an article on .NET ...
Is there a way to easily convert Crystal Reports reports to Reporting Services RDL format? We have quite a few reports that will be needing conversion soon. I know about the manual process (which is basically rebuilding all your reports from scratch in SSRS), but my searches pointed to a few possibilities with automatic conversion "acc...
We are currently using MySQL for a product we are building, and are keen to move to PostgreSQL as soon as possible, primarily for licensing reasons. Has anyone else done such a move? Our database is the lifeblood of the application and will eventually be storing TBs of data, so I'm keen to hear about experiences of performance improveme...
Anyone know a quick easy way to migrate a SQLite3 database to MySQL? ...
I'm looking for freely available resources that will help me pick up C# language and some of the basic API (like Collections). I already know Java fairly well, so looking for resources that assume background in Java. ...
Around here we have been working with a bunch of Visual Source Safe repositories for about 10 years or so. Now I want to get rid of sourcesafe and move on to Team Foundation Server. Do you have any tips or tricks for me before I embark on this migration? What are the things I have to be careful about? I am sure this migration will m...
We're in the process of redesigning the customer facing section of our site in .NET 3.5. It's been going well so far, we're using the same workflow and stored procedures for the most part, the biggest changes are the UI, the ORM (from dictionaries to LINQ), and obviously the language. Most of the pages to this point have been trivial, bu...
What is the minimum I need to add to a .NET 2.0 WebSite's web.config to make it .NET 3.5? Visual Studio adds all the config sections and script handlers, but if you aren't using those are they are really necessary? Is there a command line tool to "upgrade" a .NET 2.0 web.config to 3.5? ...
Perhaps the biggest risk in pushing new functionality to live lies with the database modifications required by the new code. In Rails, I believe they have 'migrations', in which you can programmatically make changes to your development host, and then make the same changes live along with the code that uses the revised schema. And roll bo...
The source database is quite large. The target database, doesn't grow automatically. They are on different machines. I'm coming from a MSSql, MySQl background and IDS11 seems overly complex (I am sure, with good reason) ...
I’ve been thinking about the number of projects we have inhouse that are still being developed using visual studio 6 and how best to migrate them forward onto visual studio 2008. The projects range in flavours of C/C++ and VB. Is it better to let VS2k8 convert the workspaces into solutions, fix any compile errors and be on your merry wa...
I'm on the lookout for tools to migrate from ClearCase to SVN. Ideally would like to get all history information, or as much as can be acquired. Incremental merges would be very beneficial but isn't required. ...
I maintain an old PC-only application written in Delphi 7. Although Delphi has served me very well in the past I now only use it for this one application and find my skills with the language diminishing. Its syntax is too different from my 'day job' languages of Java/Ruby so it takes me longer to get into the groove of writing new code, ...
I have a sequence of migrations in a rails app which includes the following steps: Create basic version of the 'user' model Create an instance of this model - there needs to be at least one initial user in my system so that you can log in and start using it Update the 'user' model to add a new field / column. Now I'm using "validates...
I'm looking for a general solution for upgrading database schema with ORM tools, like JPOX or Hibernate. How do you do it in your projects? The first solution that comes to my mind is to create my own mechanism for upgrading databases, with SQL scripts doing all the work. But in this case I'll have to remember about creating new scripts...
Experienced with Rails / ActiveRecord 2.1.1 You create a first version with (for example) ruby script\generate scaffold product title:string description:text image_url:string This create (for example) a migration file called 20080910122415_create_products.rb You apply the migration with rake db:migrate Now, you add a field to the produ...
I was wondering if anyone tried migrating between TS and SVN/CC. What I mean by migrating is importing and exporting the repository between source control systems without losing the history. How good are the tools to migrate to and from VSTS? I am also interested in knowing any opinion regarding using Team System from users of SVN an...