Copying reports to server

What is the best/fastest way of copying lots of user developed reports from
one server to the other.
TIA..Copy the RDL if you have access to it.
"sqlster" <trisha@.nospam.nospam> wrote in message
news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
> What is the best/fastest way of copying lots of user developed reports
> from
> one server to the other.
> TIA..|||No, this does not work. At the server the RDL does not exist as a file, it
is stored in the database. You have to either manually extract the RDL using
Report Manager or using scripting. For a lot of reports, scripting is best.
Search Books Online on the word scripting. Also, a variety of people have
posted about scripting this as well. It ships with a scripting example for
publishing reports, need to have a script to extract the reports and then
you are good to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Patrick Allmond" <patrick24601@.yahoo.com> wrote in message
news:Y_pIe.65331$5N3.3008@.bgtnsc05-news.ops.worldnet.att.net...
> Copy the RDL if you have access to it.
> "sqlster" <trisha@.nospam.nospam> wrote in message
> news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
>> What is the best/fastest way of copying lots of user developed reports
>> from
>> one server to the other.
>> TIA..
>|||Can anyone point me in the direction of a sample script ?
I know reports can be published using the rsutility, but i dont know of any
equivalent to extract or copy the rdl files once they have been uploaded.
Regards
Kamlesh
"Bruce L-C [MVP]" wrote:
> No, this does not work. At the server the RDL does not exist as a file, it
> is stored in the database. You have to either manually extract the RDL using
> Report Manager or using scripting. For a lot of reports, scripting is best.
> Search Books Online on the word scripting. Also, a variety of people have
> posted about scripting this as well. It ships with a scripting example for
> publishing reports, need to have a script to extract the reports and then
> you are good to go.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Patrick Allmond" <patrick24601@.yahoo.com> wrote in message
> news:Y_pIe.65331$5N3.3008@.bgtnsc05-news.ops.worldnet.att.net...
> > Copy the RDL if you have access to it.
> >
> > "sqlster" <trisha@.nospam.nospam> wrote in message
> > news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
> >> What is the best/fastest way of copying lots of user developed reports
> >> from
> >> one server to the other.
> >>
> >> TIA..
> >
> >
>
>

Copying MSDE database into SQL 2005

I have a legasy database developed for SQL 2000 running in MSDE. I've tried COPY DATABASE into SQL 2005 (Developer edition, to see if I can get it to work right before specing out a new server), but the user accounts don't copy and I also suspect my settings for security and permissions aren't right.

I can set SQL server security to mixed mode, and the legasy system front end Access projects to connect using Windows authentication only, but then I'm unable to control access and set roles. I need to be able to connect as a particular user in order to admin the legasy system.

Is there a fairly uncomplicated way to copy user accounts and set SQL Server options to assign roles/permissions for an MSDE legasy system copy to SQL 2005?

These articles should shed a little light on the issues:

http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872Resolve Permission Issues -Database Is Moved Between SQL Servers

Copy SQL Server Database to another Server

I have developed a SQL Server 2000 Database on my development system. I need to copy the Database to my client's Server. Unfortunately they are not linked.

What is the best way to copy the Database? Can I detach it on my Server, make a copy of the file. Copy the file to my Client's Server, and then Attach it?

OR IS THERE A BETTER WAY?

Thanks in advance for your helpDetach, copy, reattach is probably the fastest way to copy a database to another box, although there are plenty of other choices. Using BACKUP / RESTORE is probably the safest, and it doesn't take much longer than detach/copy/reattach does.

-PatP|||the best way (In My Opinion)
is to perform a transfer database task in dts
it copies everything without having to require a detach then copy then attach.
backing up and restoring is comprehensive but takes a while to perform
and the objects are in whatever state they were in when you backed em up

transfering the db is fast and you get brand new objects so for example indexes are created new so they are not fragged..

[Books Online] DTS tasks, transferring database objects