March 22, 2006 at 6:50 am
I need some tips and techniques on how to go about implementing a project I have been working on. I am somewhat of a newbie to SQL Server (3 months experience) and have been working as a contractor on a project for a local company and now need to implement the project and all its components to their server. The project was developed using SQL Server 2005 and includes a database, stored procedures, SSIS packages, and Reporting Services reports. The issue is that all of the development has been done on my local machine at home and I am not sure how to go about getting all the work I have done implemented to their server, which I do not have access to. I need to do this within the next 5 or 6 days. Any help would be greatly appreciated.
March 22, 2006 at 11:59 am
You can generate scripts of all objects using the enterprise manager.
(rightclick database->generate scripts)
You could create a blank database with all the necessary objects, back it up and restore it there.
March 22, 2006 at 2:12 pm
Jo,
Thank you for your quick reply as I am in a time crunch. Yes it looks like the scripts will work well for the database, tables, and SPs. But I still have two questions.
1) Do you think I will have a "database ownership" problem when the scripts are run at the client's site.
2) The scripts do not cover the SSIS packages and SSRS reports. Do you have any recommendations for those items.
March 22, 2006 at 2:24 pm
1)If you are only running scripts and all objects are owned bij dbo, I don't foresee problems regarding database ownership.
2)I haven't got the chance to work with sql 2005. In sql 2000 it is possible to script out all jobs. DTS packages could be saved as visual basic scripts.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply