Moving data in ARC

Create a link in the new dictionary that point to the old one (e.g. name it olddata) and then use SQL: 
   INSERT INTO mytable SELECT * FROM olddata.mytable

If you don’t use data dctionaries, you can select from the relative path: 
   INSERT INTO mytable SELECT * FROM [.\olddata\mytable]