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):
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
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