anyone has an idea on how to migrate databases from MSSQL to POSTGRESQL?
Results 1 to 10 of 16
Thread: help in migrating database
-
03-03-2009, 06:03 PM #1C.I.A.
- Join Date
- Jan 2006
- Gender
- Posts
- 4,139
help in migrating database
-
03-06-2009, 09:38 AM #2C.I.A.
- Join Date
- Jan 2006
- Gender
- Posts
- 4,139
gues wlay mkatabang nko ngari...bsan idea lng.....tools or methods...
-
03-06-2009, 10:40 AM #3Junior Member
- Join Date
- Sep 2005
- Posts
- 41
What do you mean "migrate" bai? Data or Commands or Importing? Whole structure?
-
03-06-2009, 01:34 PM #4
- Join Date
- Sep 2008
- Gender
- Posts
- 72
-
03-08-2009, 12:30 PM #5C.I.A.
- Join Date
- Jan 2006
- Gender
- Posts
- 4,139
all data and data structure...anyway im currently doing something, bt im almost half through it...i hope, it will not be a dead end...sort of manual migration...select from db1 dn insert to db2...
-
04-28-2009, 02:01 PM #6Newbie
- Join Date
- Nov 2007
- Posts
- 14
you may use SQL Server's Business Intelligence Tool . You may create SSIS Package to move data from one source to destination.
-
04-29-2009, 11:16 AM #7Banned User
- Join Date
- Oct 2003
- Posts
- 954
What ever the database type or table types, always think about compatibility. There are also TOOLS out there might be useful (with payment or free) in some ways they are not compatible with your created system made from scratch by your own hands.
Originally Posted by ingkiang
The best method is to create a script or program to REGENERATE the SQL scripts command from the MSSQL application database. Your aim is to REGENERATE DATA SQL COMMANDS into POSTGRESQL.
Create a file called. postgresql_new.sql <--- text file, contains sql commands.
Execute the sql file command into the postgresql manually and wait for it. If there is COMMAND LINE tool available in it then use it. It is very useful if you have very large data without worrying about TIME LIMITATION.
Trust me, this really works. bwahahahahahaLast edited by dodie; 04-29-2009 at 11:35 AM.
-
04-29-2009, 02:19 PM #8Junior Member
- Join Date
- Jan 2009
- Gender
- Posts
- 181
e manual input nalang na tanan data padulong sa POSTGRESQL... hahahaha...
-
04-29-2009, 03:53 PM #9Banned User
- Join Date
- Oct 2003
- Posts
- 954
bad answer. What if that guy has MEGA to GIGABYTE of data? You still want to do manual input? Originally Posted by Blacksheep666
That sounds stupid.
-
05-01-2009, 05:13 AM #10Junior Member
- Join Date
- Mar 2009
- Gender
- Posts
- 126
[TABLE BY TABLE METHOD] Originally Posted by ingkiang
pwede nimo i-convert to *.csv (comma separated value) file, then parse the data before migrating...
[MIGRATION TOOL]
Download nalng ug software...
Reply With Quote Advertisement
Similar Threads |
|
Posting Permissions
|