I am wanting to transfer objects (tables, stored procedures, data etc) between two servers (Dev box and Live box) and was wondering what the best approach for doing this is? In SQL Server 2000, you could transfer all objects and data between databases. Now all there is is 'copy data' and 'write a query'. Where has the second option gone...
What is the best way to develop on SQL Server 2005 machine locally while you get your database design and application design smoothed out and then deploy to a shared host? In the MySQL / phpMyAdmin world you have an option to export the table as the DDL Statement with the data represented as a bunch of inserts following the DDL. Using t...
Hi, One of my teammates has asked if it is possible to export from one SVN to another, all while maintaining history. To me, this seems like it would be a common request. So: Is it possible to migrate between SVN repositories all while maintaining history? It is important to note that we do not have svnadmin access on the Source, but...
I'm trying to migrate from sql server 2000 to mysql by using DTS. That's the best tool I know yet. But one a sql server tables has a column with datetime type, the DTS suggest the following sql code: `StartDate` long varbinary NULL, `EndDate` long varbinary NULL, It should be: `StartDate` DateTime NULL, `EndDate` DateTime NUL...
so i'm trying to do a data migration where i take the "listings" from a realestate app into a new "listings" app that i've created. i did startmigration like this: python manage.py startmigration listings migrate_listings --freeze realestate created a blank migration, which i populated with this: def forwards(self, orm): "Wr...
I want to keep a particular folder with all revisions before deleting the current repository from my system for security reasons (means i don't want other informations of the repository, but a particular folder).. So i am thinking of creating a new repository and to get copied the particular folder's content into it.. Can it be possible?...
i would like to have step by step instructions on how to migrate from biztalk 2002 to biztalk 2006 R2. ...
I am working on a project for a company, where I need to migrate its previous data into a new system. Obviously both structures are totally different and I'm using hibernate for database manipulation and confused as to what would be the best approach to migrate data. Should I use hibernate, should I write stored procedures, or is there a...
I'm getting this error message in production. Unfortunately this comes from a purchased application and the support process is not precisely fast. This happens when data is being copied from one table to another. Both tables are supposed to have the same columns types and length. So far I have reviewed a some of them by doing the fol...
I have to copy a bunch of data from one database table into another. I can't use SELECT ... INTO because one of the columns is an identity column. Also, I have some changes to make to the schema. I was able to use the export data wizard to create an SSIS package, which I then edited in Visual Studio 2005 to make the changes desired and w...
We get a MYSQL 5.0 dataset each month (1.7gig) and I need to create a process to migrate this to a SQL Server 2008. This seems a little harder than I first thought... I've tried a few ways: Using the Import wizard Setting up a linked server I've also tried different ways: Using the .net Framework Dataprovider for MYSQL Using MYSQ...
What are the recommended steps to be done for migrating Core Data DB changes for updated iPhone apps already shipped? Is there any prior step one need (should) have done before shipping a Core Data app? ...
Hi, I'm in the middle of a contract that is porting a company's hand-rolled Microsoft Access-based CRM to Microsoft CRM 4.0. It's all gone pretty well, but now I have to migrate the data across. The data is all over the place in the source .mdb. Lots of tables, lots of duplication, and generally shows all the signs of an ad-hoc datab...
I have a table with a lot of repeated data that I'd like to refactor as 3 tables. Current structure looks like: meeting_desc meeting_date topic_desc ... And the data in the current_table looks like: meeting1,2/3/2009,abc meeting1,2/3/2009,efg meeting1,2/3/2009,xyz meeting2,4/5/2009,aaa meeting2,4/5/2009,bbb I would like to create ...
I am using 64-bit Vista and I need to migrate an access database, in Office 2007 to SQL Server. I don't want to have to write an SSIS package to do this, but that may be my only option. Is there any other way to do this? I have about 330M of data in Access that needs to be moved, so I can write a webapp to replace this database. Updat...
I am planning to migrate a large database table from our main SQL database to a separate one. Because it's a high volume/one time process, I'm going to use SSIS. Does anyone know how best to time migrating all the data and changing the code's connection string? Quick background: Our system uses a table to log every notification that i...
I am replacing an Access application with a web app, but the client is using SQL Server 2000, and I am using SQL Server 2008. So, I have the database redesigned, with foreign keys, but now I need to get the data on the client's system. Part of the problem is that they have images that are over 32k, so osql failed as the command buffer ...
I am building php web application that let's a user upload a MS Access Database (csv export) that is then translated and migrated into a MySQL database. The MS Access database consists of one table called t_product of 100k rows. This table is not designed well. As an example, the following query: SELECT part_number, model_number FR...
I'm trying to income data from a MSSQL (2005) table to MYSQL (5) table, using SSIS, all fields insert correctly. Except one field that his type is TEXT in MSSQL to MYSQL TEXT field, and always this field is get NULL ! ...
I had a discussion with our DBA about how to change a database schema. His opinion is that all changes must be reversible. For example: Obsolete tables/columns should not be dropped as soon as they become redundant. Instead, they should be kept for at least a few releases. Instead of renaming a table/column, create a new table/column a...