{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 叼着烟拽天下 的问题《After performing Oracle to SQL Server Migration I》','https://www.manongdao.com/q-1002670.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I recently did a Oracle to SQL Server 2008 R2 Migration. The PL/SQL stored procedures were converted to T/SQL by SSMA. The converted T/SQL has many references to the sysdb database, for instance sysdb.ssma_oracle.db_check_init_package
I then exported the SQL Server 2008 R2 database, and imported it to SQL Server 2012. However I forgot to copy the sysdb database. What is the easiest way of creating the sysdb database?
Thank you!
Just install
SSMA for Oracle 5.2 Extension Pack.exe(downloadable from Microsoft) on the computer with the SQL Server database (tell it to ignore the fact that Oracle is not installed on the computer) and it will create the sysdb database for you, and also the Extended Stored Procedures that it needs.