Migrate SSRS 2005 Reports

Hi,

I need to move few folders from our DEV SSRS 2005 environment to another
server. Folders will be moved to new parent folders.
Is there any tool that I can use fot this purpose?
I used RSScripter from SQLdbatips.com. Although the tool works great but it
can't script multiple folder reports. I have to script one by one and it is
a big problem.

Thanks
AlexIt cannot? I have version 2.0.0.6 and I can select multiple folders.

migrate SQL 2000 system users

I have installed a new SQL 2005 server and successfully moved a db from one to the other. The users from that db were also imported, but the system security was not. Users cannot access the SQL system to even attempt to login to the db. What am I missing to import/transfer/migrate the system logins from SQL2000 to SQL2005?

Thanks

David

Moving to the setup and upgrade forum.

Donald

|||

Take a look at http://support.microsoft.com/kb/918992/

Thanks,

Peter

Microsoft SQL Server Management Studio

I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
2005.
In the good old Enterprise Manager, when I imported a table from a SQL
server to another, I could choose "Copy objects and data between SQL
Server
databases". When choosen, all primary keys, and default values was
copied.
My question is:
Is it possible to do the same in Microsoft SQL Server Management Studio
with
SQL Server 2005? And how do I do it?
I have tried using the "SELECT * INTO NewTable FROM OldTable"
statement, but
it just drops all information about primary keys and default values.
Best Regards
Right click on the database in Object Explorer and choose "All Tasks". Then
choose export and follow the wizard.
Andrew J. Kelly SQL MVP
<pd@.acskive.dk> wrote in message
news:1143018478.487953.10000@.i40g2000cwc.googlegro ups.com...
>I have recently moved from a Microsoft SQL Server 2000 to a SQL Server
> 2005.
> In the good old Enterprise Manager, when I imported a table from a SQL
> server to another, I could choose "Copy objects and data between SQL
> Server
> databases". When choosen, all primary keys, and default values was
> copied.
> My question is:
> Is it possible to do the same in Microsoft SQL Server Management Studio
> with
> SQL Server 2005? And how do I do it?
> I have tried using the "SELECT * INTO NewTable FROM OldTable"
> statement, but
> it just drops all information about primary keys and default values.
>
> Best Regards
>