Importing subscriptions from RS 2000 to RS 2005

Hi, I am moving from SQL server 2000 to SQL server 2005. I'am also moving to the new Reporting services 2005. There are almost 400 reports and like 100 subscriptions under the actual configuration. I have imported the reports but I don't know how to recreate the subscriptions.

Any ideas?

Thanks,
Alejandro Gutierrez.

It sounds like to did not upgrade, but you are rather trying to migrate the contents to RS 2005. You could move the subscriptions for instance by making SOAP calls to retrieve the settings from one server and apply them on the other server.

A tool I found quite useful for performing this kind of job is Jasper Smith's RS Scripter: http://www.sqldbatips.com/showarticle.asp?ID=62

-- Robert

|||

Yes, I'm migrinting to another server. That tool seems pretty cool. I'm going to give it a try. Thanks a bunch !!!

Alejandro.l

sql

Importing More Than 10'000 Rows

Hi,
I have been tasked with moving a company database from MS Access to SQL
Server 2000. The problem I have is that there are some very large tables
which I need to import from the Access version to SQL Server. One of these,
for example, is just under 33'000 records in size. Is there a way that I can
import all of these records in one go. I can only import 10'000 at a time.
Many thanks in advance to anyone who might be able to help
Hi
Have you look into DTS?
"Tomsky02" <Tomsky02@.discussions.microsoft.com> wrote in message
news:2EE92E2F-D6B2-461D-9D2F-743DD2030522@.microsoft.com...
> Hi,
> I have been tasked with moving a company database from MS Access to SQL
> Server 2000. The problem I have is that there are some very large tables
> which I need to import from the Access version to SQL Server. One of
> these,
> for example, is just under 33'000 records in size. Is there a way that I
> can
> import all of these records in one go. I can only import 10'000 at a time.
> Many thanks in advance to anyone who might be able to help
|||Hi Uri,
Thanks for the reply. I solved the problem. I was being a bit of an idiot
and had the number of records to be displayed in my forms as 10000. I upped
this and everything is ok now.
Thanks,
Tom.
"Uri Dimant" wrote:

> Hi
> Have you look into DTS?
> "Tomsky02" <Tomsky02@.discussions.microsoft.com> wrote in message
> news:2EE92E2F-D6B2-461D-9D2F-743DD2030522@.microsoft.com...
>
>

Importing More Than 10'000 Rows

Hi,
I have been tasked with moving a company database from MS Access to SQL
Server 2000. The problem I have is that there are some very large tables
which I need to import from the Access version to SQL Server. One of these,
for example, is just under 33'000 records in size. Is there a way that I can
import all of these records in one go. I can only import 10'000 at a time.
Many thanks in advance to anyone who might be able to helpHi
Have you look into DTS?
"Tomsky02" <Tomsky02@.discussions.microsoft.com> wrote in message
news:2EE92E2F-D6B2-461D-9D2F-743DD2030522@.microsoft.com...
> Hi,
> I have been tasked with moving a company database from MS Access to SQL
> Server 2000. The problem I have is that there are some very large tables
> which I need to import from the Access version to SQL Server. One of
> these,
> for example, is just under 33'000 records in size. Is there a way that I
> can
> import all of these records in one go. I can only import 10'000 at a time.
> Many thanks in advance to anyone who might be able to help|||Hi Uri,
Thanks for the reply. I solved the problem. I was being a bit of an idiot
and had the number of records to be displayed in my forms as 10000. I upped
this and everything is ok now.
Thanks,
Tom.
"Uri Dimant" wrote:

> Hi
> Have you look into DTS?
> "Tomsky02" <Tomsky02@.discussions.microsoft.com> wrote in message
> news:2EE92E2F-D6B2-461D-9D2F-743DD2030522@.microsoft.com...
>
>

Importing More Than 10'000 Rows

Hi,
I have been tasked with moving a company database from MS Access to SQL
Server 2000. The problem I have is that there are some very large tables
which I need to import from the Access version to SQL Server. One of these,
for example, is just under 33'000 records in size. Is there a way that I can
import all of these records in one go. I can only import 10'000 at a time.
Many thanks in advance to anyone who might be able to helpHi
Have you look into DTS?
"Tomsky02" <Tomsky02@.discussions.microsoft.com> wrote in message
news:2EE92E2F-D6B2-461D-9D2F-743DD2030522@.microsoft.com...
> Hi,
> I have been tasked with moving a company database from MS Access to SQL
> Server 2000. The problem I have is that there are some very large tables
> which I need to import from the Access version to SQL Server. One of
> these,
> for example, is just under 33'000 records in size. Is there a way that I
> can
> import all of these records in one go. I can only import 10'000 at a time.
> Many thanks in advance to anyone who might be able to help|||Hi Uri,
Thanks for the reply. I solved the problem. I was being a bit of an idiot
and had the number of records to be displayed in my forms as 10000. I upped
this and everything is ok now.
Thanks,
Tom.
"Uri Dimant" wrote:
> Hi
> Have you look into DTS?
> "Tomsky02" <Tomsky02@.discussions.microsoft.com> wrote in message
> news:2EE92E2F-D6B2-461D-9D2F-743DD2030522@.microsoft.com...
> > Hi,
> > I have been tasked with moving a company database from MS Access to SQL
> > Server 2000. The problem I have is that there are some very large tables
> > which I need to import from the Access version to SQL Server. One of
> > these,
> > for example, is just under 33'000 records in size. Is there a way that I
> > can
> > import all of these records in one go. I can only import 10'000 at a time.
> >
> > Many thanks in advance to anyone who might be able to help
>
>

Importing databases in SQL 2005

I'm having a lot of trouble importing/moving databases between SQL2005
servers.
-If i detach/copy files/attach, I get user security problems (ie. user
defined in database "does not exist" on new server, but cannot be removed
from database as owns schemas etc.)
-Same with Backup/restore
-If I try to copy or import data after creating a "blank" database with only
the user ID in question as dbo, I lose primary keys.
All actions are being performed through Management Console with the SQL
admin ID. Most databases are running in 2000 compatability mode following the
recent upgrades. Servers are not on Active Directory.
Can someone give me some hints about how to migrate databases?
Seems that some Login of the Source Server is not existing on the Target
Server. If it is so, then first create those Logins on the Target Server and
then try the Backup/Restore method.
"The Vogon" wrote:

> I'm having a lot of trouble importing/moving databases between SQL2005
> servers.
> -If i detach/copy files/attach, I get user security problems (ie. user
> defined in database "does not exist" on new server, but cannot be removed
> from database as owns schemas etc.)
> -Same with Backup/restore
> -If I try to copy or import data after creating a "blank" database with only
> the user ID in question as dbo, I lose primary keys.
> All actions are being performed through Management Console with the SQL
> admin ID. Most databases are running in 2000 compatability mode following the
> recent upgrades. Servers are not on Active Directory.
> Can someone give me some hints about how to migrate databases?
|||Thanks for the reply... I'll try that again and let you know...
"Absar Ahmad" wrote:
[vbcol=seagreen]
> Seems that some Login of the Source Server is not existing on the Target
> Server. If it is so, then first create those Logins on the Target Server and
> then try the Backup/Restore method.
> "The Vogon" wrote:

Importing databases in SQL 2005

I'm having a lot of trouble importing/moving databases between SQL2005
servers.
-If i detach/copy files/attach, I get user security problems (ie. user
defined in database "does not exist" on new server, but cannot be removed
from database as owns schemas etc.)
-Same with Backup/restore
-If I try to copy or import data after creating a "blank" database with only
the user ID in question as dbo, I lose primary keys.
All actions are being performed through Management Console with the SQL
admin ID. Most databases are running in 2000 compatability mode following th
e
recent upgrades. Servers are not on Active Directory.
Can someone give me some hints about how to migrate databases?Seems that some Login of the Source Server is not existing on the Target
Server. If it is so, then first create those Logins on the Target Server and
then try the Backup/Restore method.
"The Vogon" wrote:

> I'm having a lot of trouble importing/moving databases between SQL2005
> servers.
> -If i detach/copy files/attach, I get user security problems (ie. user
> defined in database "does not exist" on new server, but cannot be removed
> from database as owns schemas etc.)
> -Same with Backup/restore
> -If I try to copy or import data after creating a "blank" database with on
ly
> the user ID in question as dbo, I lose primary keys.
> All actions are being performed through Management Console with the SQL
> admin ID. Most databases are running in 2000 compatability mode following
the
> recent upgrades. Servers are not on Active Directory.
> Can someone give me some hints about how to migrate databases?|||Thanks for the reply... I'll try that again and let you know...
"Absar Ahmad" wrote:
[vbcol=seagreen]
> Seems that some Login of the Source Server is not existing on the Target
> Server. If it is so, then first create those Logins on the Target Server a
nd
> then try the Backup/Restore method.
> "The Vogon" wrote:
>

Importing databases in SQL 2005

I'm having a lot of trouble importing/moving databases between SQL2005
servers.
-If i detach/copy files/attach, I get user security problems (ie. user
defined in database "does not exist" on new server, but cannot be removed
from database as owns schemas etc.)
-Same with Backup/restore
-If I try to copy or import data after creating a "blank" database with only
the user ID in question as dbo, I lose primary keys.
All actions are being performed through Management Console with the SQL
admin ID. Most databases are running in 2000 compatability mode following the
recent upgrades. Servers are not on Active Directory.
Can someone give me some hints about how to migrate databases?Seems that some Login of the Source Server is not existing on the Target
Server. If it is so, then first create those Logins on the Target Server and
then try the Backup/Restore method.
"The Vogon" wrote:
> I'm having a lot of trouble importing/moving databases between SQL2005
> servers.
> -If i detach/copy files/attach, I get user security problems (ie. user
> defined in database "does not exist" on new server, but cannot be removed
> from database as owns schemas etc.)
> -Same with Backup/restore
> -If I try to copy or import data after creating a "blank" database with only
> the user ID in question as dbo, I lose primary keys.
> All actions are being performed through Management Console with the SQL
> admin ID. Most databases are running in 2000 compatability mode following the
> recent upgrades. Servers are not on Active Directory.
> Can someone give me some hints about how to migrate databases?|||Thanks for the reply... I'll try that again and let you know...
"Absar Ahmad" wrote:
> Seems that some Login of the Source Server is not existing on the Target
> Server. If it is so, then first create those Logins on the Target Server and
> then try the Backup/Restore method.
> "The Vogon" wrote:
> > I'm having a lot of trouble importing/moving databases between SQL2005
> > servers.
> > -If i detach/copy files/attach, I get user security problems (ie. user
> > defined in database "does not exist" on new server, but cannot be removed
> > from database as owns schemas etc.)
> > -Same with Backup/restore
> > -If I try to copy or import data after creating a "blank" database with only
> > the user ID in question as dbo, I lose primary keys.
> >
> > All actions are being performed through Management Console with the SQL
> > admin ID. Most databases are running in 2000 compatability mode following the
> > recent upgrades. Servers are not on Active Directory.
> >
> > Can someone give me some hints about how to migrate databases?

importing data issue

Hello,
We are moving our data from one sql2k to another. The initial db has all
of the tables in a primary filegroup. We have created multiple filegroups
for the new server from scripts. When we try to import the data from the old
sql to the new we get a bunch of FK and PK violations. Is this a way to shut
all of these off for the import and then turn them all back on or do we have
to do each table separately? Thanks in advance.
JohnThe PK violations implies that there is something wrong
with the import. You need to make sure the data added is
correct. Something like a different collation could cause
this.
FK - you just need to import the tables in the correct
order. ANother option is to remove all the FKs and add
them after the import.
Given that you seem to have problems wit hthe data I
would make sure the data is checked when the FKs are
added.