jeudi 3 mars 2016

Transfering a SQL Database on AWS

We have a SQL Server 2005 database on our local server.

Here it is (ofc i've to repeat the proceder for the other databases):

Here it is:

I've to transfer it to our SQL server 2012 instance on Amazon RDS.

I right clicked the database and selected Generate Scripts - All tables - Copy Schema and Data and saved everything as a sql file

enter image description here

At this point i attempted to use the SQL Azure MW v5.15 (in a question here i saw that it works with AWS too, way to go Microsoft!) to transfer the database on AWS. However it crashes. No problem, i try to use SQL Management studio to import the file but as soon the RAM consumed by the program reaches 1gb (as you can see that DB is 3,4gb) BOOM - out of memory error! What should i do now?

Aucun commentaire:

Enregistrer un commentaire