3
I need to migrate my SQL server database to Postgre-SQL, but I don’t have much database intimacy. Is there any tool that can assist in migrating? I have the backup of MS SQL . Bak is it possible to convert it? Grateful!
1 answer
0
The beginning of an export from a database to files that can be imported into Postgresql is to find and open in the SQL SERVER menu the tool IMPORT AND EXPORT DATA. After locating, you should open this option, in which a welcome window will appear from DTS (DATA TRANSFORMATION SERVICES IMPORT/EXPORT WIZARD). By clicking Next we move to the next level where we will choose From where we will export the data, after these options we still have the last and most important, in which will be the choice of the database in which we will connect to export.
Just follow the step by step of this tutorial: Migrating from SQL Server to Postgresql
-
Opa, @Paulorober took a look at the tutorial, a doubt that still remains, (because I forgot to mention that I am not using operating system Windows this requirement is only possible if I have an SQL server installed on WINDOWS?
-
@Aristotle Coutinho now you got me, but I believe that the system is the same because this function is not of the Operating System but of the database.
Browser other questions tagged sql-server postgresql migrations
You are not signed in. Login or sign up in order to post.
Yes, it is possible. Postgresql has a full Wiki on it. Take a look: wiki.postgresql.org/wiki/Microsoft_sql_server_to_postgresql_migration_by_ian_harding
– guiandmag