migrate

How to replace $*=1 with an alternative now $* is no longer supported

Hi, I'm a complete perl novice, am running a perl script using perl 5.10 and getting this warning: $* is no longer supported at migrate.pl line 380. Can anyone describe what $* did and what the recommended replacement of it is now? Alternatively if you could point me to documentation that describes this that would be great. The scri...

Load Excel data sheet to Oracle database

I am looking for a free tool to load Excel data sheet into Oracle database. I tried oracle sql developer, but it keeps throwing NullPointerException. Any ideas? ...

How would you migrate a multi-site ClearCase/ClearQuest environment to all Open Source?

I work in an multi-site environment that's currently using Rational ClearCase for source control and Rational ClearQuest for issue tracking (I accept your condolences ahead of time). As a rough estimate I would say this is supporting 200 engineers. How would you effectively migrate this SCM methodology to a comparative, all Open Source...

How do I preserve installed applications when migrating Ubuntu to another platform?

I'm looking at maybe moving from an older AMD64 to a new Intel dual-core which is 32 bit. Installation isn't a problem but can I transfer all the installed apps? I haven't been able to find anything so far on Google except where the migration is to a similar platform and file-system. I won't change the filesystem but the platform will be...

Copy tables from one database to another in SQL Server.

I have a database called foo and a database called bar. I have a table in foo called tblFoobar that I want to move (data and all) to database bar from database foo. What is the SQL statement to do this? ...

Migrate table from MS SQL Server to MySQL

Hello, I have to migrate a table from MSSQL Server to MySql. The problem is that the table is quite big (65 millions records) and the whole process takes too much time. Does anyone have any idea how to speed things up ? Any useful tools that could improve this? ...

Basic MS SQL Server 2008 questions

Can you import (or migrate) SQL Server 2005 databases to SQL Server 2008? Is it possible to have the same 2005 and 2008 running on the same machine without complications? ...

Migrating content from OpenWiki to ScrewTurn Wiki

We have a large OpenWiki powered wiki. OpenWiki appears to be a dead project, and ScrewTurn the next best option. Is anyone aware of a data migration route to move our content from the OpenWiki SQL Server format to the ScrewTurn wiki SQL Server format? We may end up creating our own (and sharing it) but we'd rather not re-invent the wh...

How do you migrate an IIS 7 site to another server?

I'm new to the IIS world but am wondering the best practice for moving a website to another server (along with all settings, etc.) Manually recreate the site on the new server (not maintainable for obvious reasons) Copy the applicationHost.config settings file Use appcmd to make a backup and restore Use MSDeploy to publish the site on ...

Which tool do you suggest, to convert a legacy delphi 7.0 app to c#

A simple google query shows a bunch of tools, which seems to convert Delphi to C# code. Example: http://www.google.de/search?q=delphi+c%23+converter Do you have experience with one of this tools or the approach of migration source from Delphi to the .NET platform? Is this a viable option? Our general conditions: Delphi 7.0 Platform...

How to migrate existing asp.net application to asp.net MVC pattern format

I want to migrate existing asp.net application to asp.net MVC pattern format now. What procedure should I will follow? Any step-by-step instructions would be very helpful. ...

Converting non-standard Subversion repository to git.

I have a repository whose layout is like this: trunk/ projectA projectB branches/ projectA-1.0 projectB-1.0 tags/ projectA-1.0.1 projectB-1.0.1 I want to convert them to separate git repositories with the trunk/projectA as the top-level directory and all it's branches as git...

Reasons for migrating from MySQL 5.0 to 5.1

I'm using a rather busy MySQL 5.0 database. What are the main reasons for me to migrate to MySQL 5.1? Does it worth the trouble? I use VS2008/.NET 3.5 Servers run as a MySQL cluster on Windows 2008 servers. Thank you for your answers so far. To be more specific - I'm looking for answers such as the one by Quanssnoi, listing the feature...

How do I migrate my website, mySQL, php pages, files, settings etc to Amazon EC2?

Hi I am completely new to EC2 and new to server admin and have been working on a windows 2003 server with our current web application made with PHP pages, mySQL database, and serving image files from a single standalone windows 2003 server. I would like to know how to go about 'packing up' our server and installing it as an image on Am...

Is there a rake task for advancing or retreating your schema version by exactly one?

Back when migration version numbers were simply incremented as you created migrations, it was easy enough to do: rake migrate VERSION=097 rake migrate VERSION=098 rake migrate VERSION=099 rake migrate VERSION=100 ...but we now have migration numbers that are something like YYYYMMDDtimeofday. Not that this is a bad thing - it keeps th...

How to update a database schema without losing your data with Hibernate?

Hi everybody! Imagine you are developing a Java EE app using Hibernate and JBoss. You have a running server that has some important data on it. You release the next version of the app once in a while (1-2 weeks) and they have a bunch of changes in the persistence layer: New entities Removed entities Attribute type changes Attribute na...

Database Migration

I am working on database migration tool in java. The tool is copying database tables with their data's to the destination database. But i want it to work on different databases. Copy from mysql and create in derby etc. With JDBC, we can gather enough information about the table and its columns. But i am going to ask this, if i can recrea...

Porting Jboss/Seam App to newer versions

Hi, I have a Web App running using SEAM 2.0.2 on JBoss 4.2. When I tried to run it using Seam 2.1 and JBoss 5, all sorts of problems arised. Is there a porting guide available for this scenario that you're aware of ? Thanks. ...

how to migrate from sql 2000 to sql 2008 via restore?

I'm running this code: RESTORE DATABASE [MyDB_2009May11] FROM DISK = N'C:\DB Copy\MyDB_2009May11.bak' WITH MOVE N'Archive_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\MyDB_2009May11.mdf', MOVE N'Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQL\DATA\MyDB_2009May11.mdf'...

migrate from C#.net 2.0 to php so the hash value of the password - how to resolve?

Hi we previously use a C#.net 2.0 to create a web app. Users password were hashed and stored in database using the following code. private const string encryptionKey = "AE09F72B007CAAB5"; HMACSHA1 hash = new HMACSHA1(); hash.Key = HexToByte(encryptionKey); encodedPassword = Convert.ToBase64String( hash.ComputeHash(Encoding.Unicod...