Thank you Hugo. The thing is I won't be allowed to download and use unlicensed software and we don't have a copy of that app. The database is approximately 4gb... I had just created a "transfer sql server objects task" package using ssis, but I discovered there isn't any Integration services installed on the prod side.....and on the test side where the data is supposed to go to, we have integration services installed. I imported the ssis package into msdb(cos i couldn't find file system) and created a job to run it from there and it failed "access denied".

I tried to right-click on the package itself and run it from msdb and it failed "nothing to copy"... I setup the connections properly in visual studio while creating the ssis package so im really confused now.

are there any sequence of steps that i could follow, i mean rather than using any third party tools?

Export wizard? what do you think?