Database migration

[muralidharand]

Hi experts,

During our first install (alfresco 4 enterprise edition), we have used to postgres database and we have used it for a month. Now, we want to change the datasbase instead of using postgres we wanted to sql server.
How I can move the existing data from postgres to sql server?
During this migration is there any data loss will be there ?
Any database migration tool is available?

[amitabhandari1]

Hi,

We have also similar requirement. Did you get anything for this.

Thanks,

[muralidharand]

Hi,
I'm planning to use SSIS to import the data from postgresql to sql server.

You can refer this link for more information.
http://stackoverflow.com/questions/3711028/migrating-from-postgres-to-sql-server-2008