I'm writing a plug-in for another program through an API. To save it's current state, my plugin stores an instance of a Project object to the file by serializing it to XML and storing it in a user string, a feature provided by the API. It also stores a separate string that contains the version number of the plug-in currently being used. ...
Hi, I hava a sqlite3 database placed in the documents folder. I need to sync this database with the sql server 2005, which is running at our server. Is there a possibility that i can do a Replication between a sqlite3 database and a MSSql server 2005. -- Regards, Syed Yusuf ...
I need to create a quick and dirty solution to migrate data from database into another. This is only being used a proof of concept. Long term we will use .NET's Sync Framework. The databases are identical. The solution is going to be used as an OCA (occasionally connected application). I read in which tables they want to migrate fro...
I'm overhauling a site I'd originally made using Joomla to Django, and I was wondering if I can import the user records directly from Joomla (my main concern is the user passwords as they are encrypted). ...
I have Migrator.net implemented in my project and I am removing a table from the current schema. My Up() simply contains Database.RemoveTable("FooTable"). But now I'm at a bit of a loss as to what I'm supposed to do for my Down(). Do I need to manually parse all past migrations for modifications on FooTable? Is there a way to run all pre...
Hi, I'm doing data migration between two SQL Server 2008 database using SSIS because I need to do some data transformation. I guess I need to use Business Intelligence Developement Studio which I have on my develop machine. But because I don't have SQL Server Standard Edition on my develop machine. The BIDS do not allow me to build the ...
Hi, all Is that possible for BIDS to build a SSIS package on remote SQL Server instance? Since I only have SQL Server Standard Edition on the production server. BTW, when I use BIDS to build a Integration Service Connection Project, it throws a exception like this: exception of type 'System.Exception' was thrown And nothing is created....
Hello, I have an application which is in BETA mode. The model of this app has some classes with an explicit primary_key. As a consequence Django use the fields and doesn't create an id automatically. class Something(models.Model): name = models.CharField(max_length=64, primary_key=True) I think that it was a bad idea (see http://...
I am trying to migrate data from SQL Server to mysql, and i'd like to do that using insert-statements, so i modified this nice script by Narayana Vyas Kondreddi to generate mysql-friendly code and everything works fine so far. the problem being columns of the TEXT datatype that can be more than 8000 characters long (containing long blo...
We are creating several SSIS packages to migrate a large database as part of a release cycle. We may end up with about 5-10 SSIS packages. As we have 4 environments (dev, QA, staging, production, etc.), is there an efficient way to change the destination server for each SSIS package as they go through the different server environments...
Hello, I'm using SQL Server 2005. I am migrating data over from a current database (single table) to a new database (normalized - many tables). In the new database, I have a base table (let's call it "BaseTable"), and multiple other tables (let's call them "DependentA", and "DependentB"). Some of the data from the old database will go t...
Hi there, Are there any Ruby gems/libraries that help you migrate from an old DB structure to a new structure? ActiveRecord migrations do a good job keeping track of a new db structure, but I wonder if there's something that helps you migrate an entire legacy db to a new structure: transfer_from(:source_table => 'person', :destination_...
Hi, I am trying to use the HSQLDB transfer tool to migrate a Database from MySQL. The tool is able to get the tables from the source MySQL database, however when I "start the transfer" I get the error,as follows and tables are not created in the target HSQLDB database. org.hsqldb.util.DataAccessPointException: Unexpected token: PRIMARY...
How do I migrate users from a existing users table to Forms Authentication? There seems to be three options: T-SQL - Iterate through the existing users table and insert into Forms Authentication tables using the stored procedure aspnet_Membership_CreateUser Code - create a utility that will iterate through the existing users table and...
Hi I would like to make my app able to do an automatic lightweight migration when I add new attributes to my core data model. In the guide from Apple this is the only info on the subject I could find: Automatic Lightweight Migration To request automatic lightweight migration, you set appropriate flags in the options dicti...
Hi, I have an ASP MVC-application that uses a SQL server express for and Forms authentication. The server im using does not have enough memory to run SQL Server express stable and I was thinking about migrating to SQLite instead. Is it possible to just migrate the existing aspnetdb-database from SQL Server to SQLite so that all my user...
i want to migrate my whole DB from MySQL to MS-Sql server. though i am open to use any tool,am restricted to use only free avilable tools. ...
Hey, I am releasing a Core Data based app and wondered what I need to consider if, in an update later down the line, I need to change the model. How do I move existing user data on the device from the old data model into a new updated model? Thanks ...
I'm wanting to incorporate HTML5 database storage into my web application to make it online-accessible. I've done lots of development in server-side environments with databases, and we all know that database schema additions and modifications are often necessary. I am wondering what should happen if my application uses an offline datab...
Hi, I am currently in the process of creating a new news/publishing site on the Movable Type platform. There are around 20 or so sites with 20,000+ rows of data to be moved/aggregated to ~8 sites (we have a number of location specific sites and are going to aggregate the content from these into 1 single site for each niche). We have di...