I am trying to copy some objects from one model to another.
Both of them sql2005 physical models.
Size of one about 12m and the second one about 500k.
(About: 200 tables, 100 views, 50 procedures, assemblies and more)
I tried to do this by Alter Scripting, Model Merge.
On Converter Screen it stopped to response for very long time ,
on every change.
Finally it backed, but when i pressed Execute button it died again ,
until i got message of “out of memory”.
I am running on:
Microsoft Windows XP
Service Pack 3
Intel® Core™2 Duo CPU
E8400 @ 3.00GHz
2.99 GHz, 3.46 GB of RAM
I am DBA and Developer there is no problem of memory with
Visul Studio or SQL Manager Studio for few instances and large files(projects).
Maybe my use of tool is wrong or
there is some different way to copy objects from model to model