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..
> >
> >
>
>
Showing posts with label fastest. Show all posts
Showing posts with label fastest. Show all posts
Tuesday, March 20, 2012
Wednesday, March 7, 2012
COPYING a DB from one server to another
I was trying to find the fastest way to COPY a 50G DB from our production server to our test server. I was testing this on our test server and had a simple question.
Attach/Detach is out since I can only move not copy a DB using this method.
export/import, bcp and DTS take too long and are not indented for this anyways.
so, I was left with Backup and restore. so, I tried that on two different test servers. Took very long. so, I decided to be brave and try the following.
1. Take DB1 that's running on server1 OFFLINE
2. Manually copy all datafiles and logfiles from Server1 to server2.
3. Attach DB1 on server2.
It came up great. No complaints whatsoever. So basically, it's the same as attach/detach but instead of detaching the DB I took the Db offline and copied the files over. So my question...
Is this supported?
Any chance of corruption on either of the servers?
If a DB is offline, is copying datafiles and logfiles supported (I am bit worried if I might corrupt data in production).
Do people use this method to COPY databases or do they stick with BACKUP and RESTORE?
PS: Are there any other ways to do this?
Thanks so much.Just detach DB copy ( COPY do not MOVE) log & data to new server.
Attach to old server.
Attach to new server.
I have just stopped the server and copied the files, but I am afraid that sometimes it may not stop the DBs as nicely as if detaching them.
Tim S|||thanks. That makes sense.|||I don't think these methods are currently supported by MS. But if db is cleanly closed (i.e. taken offline or server orderly stopped), db files copied and attached to another server, according to several books I've read (for example Inside SQL Server) everything should be OK. I've done that many times myself without slightest problems. mojza|||Detaching is preferred simply because taking a db off-line already prevents any access to it, but leads to issues in other activities. Example could be you transaction log dumps based on maintenance plans, which will start failing if "All user databases" option is selected. Contrary, if you detach it, it gets removed from sysdatabases and everything else goes well.
EDITED: Why are you saying that these methods are not supported by MS? Which book says that?|||Kalen Delaney-Inside SQL Server 2000, in section on attaching, detaching dbs. I haven't got it here, so I cannot tell you exact page number. It was something like you're not supposed to do that but it works fine anyway. mojza
Attach/Detach is out since I can only move not copy a DB using this method.
export/import, bcp and DTS take too long and are not indented for this anyways.
so, I was left with Backup and restore. so, I tried that on two different test servers. Took very long. so, I decided to be brave and try the following.
1. Take DB1 that's running on server1 OFFLINE
2. Manually copy all datafiles and logfiles from Server1 to server2.
3. Attach DB1 on server2.
It came up great. No complaints whatsoever. So basically, it's the same as attach/detach but instead of detaching the DB I took the Db offline and copied the files over. So my question...
Is this supported?
Any chance of corruption on either of the servers?
If a DB is offline, is copying datafiles and logfiles supported (I am bit worried if I might corrupt data in production).
Do people use this method to COPY databases or do they stick with BACKUP and RESTORE?
PS: Are there any other ways to do this?
Thanks so much.Just detach DB copy ( COPY do not MOVE) log & data to new server.
Attach to old server.
Attach to new server.
I have just stopped the server and copied the files, but I am afraid that sometimes it may not stop the DBs as nicely as if detaching them.
Tim S|||thanks. That makes sense.|||I don't think these methods are currently supported by MS. But if db is cleanly closed (i.e. taken offline or server orderly stopped), db files copied and attached to another server, according to several books I've read (for example Inside SQL Server) everything should be OK. I've done that many times myself without slightest problems. mojza|||Detaching is preferred simply because taking a db off-line already prevents any access to it, but leads to issues in other activities. Example could be you transaction log dumps based on maintenance plans, which will start failing if "All user databases" option is selected. Contrary, if you detach it, it gets removed from sysdatabases and everything else goes well.
EDITED: Why are you saying that these methods are not supported by MS? Which book says that?|||Kalen Delaney-Inside SQL Server 2000, in section on attaching, detaching dbs. I haven't got it here, so I cannot tell you exact page number. It was something like you're not supposed to do that but it works fine anyway. mojza
Friday, February 17, 2012
copy table from a server to another server
hi guys,
I have a question about copying a table's data from one server to
another server. I want the fastest way to do it. basically, I'm using DTS
wizard to copy but it takes more than 10 minutes because there are a lot of
rows. I wonder if I use BCP by copy data to a file and do bulk insert from a
file, then will it be faster? I 'm not sure because it seems like I'm doing
2 steps instead of 1 step via DTS wizard.
I want to copy data over as fast as possible. Wondering what you guys do in
my situation.
thanks
KevinIs the server on the same network? If so, maybe try this:
INSERT [server].[database].[owner].[table]
SELECT [columns] FROM [table]
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:%23O7r4yEwFHA.2864@.TK2MSFTNGP10.phx.gbl...
> hi guys,
> I have a question about copying a table's data from one server to
> another server. I want the fastest way to do it. basically, I'm using
> DTS wizard to copy but it takes more than 10 minutes because there are a
> lot of rows. I wonder if I use BCP by copy data to a file and do bulk
> insert from a file, then will it be faster? I 'm not sure because it
> seems like I'm doing 2 steps instead of 1 step via DTS wizard.
> I want to copy data over as fast as possible. Wondering what you guys do
> in my situation.
> thanks
> Kevin
>|||BCP should be faster
I mean try it out see what the time difference is
http://sqlservercode.blogspot.com/
"Kevin" wrote:
> hi guys,
> I have a question about copying a table's data from one server to
> another server. I want the fastest way to do it. basically, I'm using DT
S
> wizard to copy but it takes more than 10 minutes because there are a lot o
f
> rows. I wonder if I use BCP by copy data to a file and do bulk insert from
a
> file, then will it be faster? I 'm not sure because it seems like I'm doi
ng
> 2 steps instead of 1 step via DTS wizard.
> I want to copy data over as fast as possible. Wondering what you guys do
in
> my situation.
> thanks
> Kevin
>
>|||yes, the same network.
but why is your way different from dts or better than DTS?
I don't think it's faster.
"Yosh" <yoshi@.nospam.com> wrote in message
news:eTpbw1EwFHA.1132@.TK2MSFTNGP10.phx.gbl...
> Is the server on the same network? If so, maybe try this:
> INSERT [server].[database].[owner].[table]
> SELECT [columns] FROM [table]
>
> "Kevin" <pearl_77@.hotmail.com> wrote in message
> news:%23O7r4yEwFHA.2864@.TK2MSFTNGP10.phx.gbl...
>|||I thought there are some kinds of table setting I can tweak so I can avoid
transaction log. I know one thing, I can remove indexes to speed up the
copying, but what other tricks do you have?
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:487F4412-7B52-4B5A-A8C4-8B57A6512E15@.microsoft.com...
> BCP should be faster
> I mean try it out see what the time difference is
> http://sqlservercode.blogspot.com/
>
> "Kevin" wrote:
>
I have a question about copying a table's data from one server to
another server. I want the fastest way to do it. basically, I'm using DTS
wizard to copy but it takes more than 10 minutes because there are a lot of
rows. I wonder if I use BCP by copy data to a file and do bulk insert from a
file, then will it be faster? I 'm not sure because it seems like I'm doing
2 steps instead of 1 step via DTS wizard.
I want to copy data over as fast as possible. Wondering what you guys do in
my situation.
thanks
KevinIs the server on the same network? If so, maybe try this:
INSERT [server].[database].[owner].[table]
SELECT [columns] FROM [table]
"Kevin" <pearl_77@.hotmail.com> wrote in message
news:%23O7r4yEwFHA.2864@.TK2MSFTNGP10.phx.gbl...
> hi guys,
> I have a question about copying a table's data from one server to
> another server. I want the fastest way to do it. basically, I'm using
> DTS wizard to copy but it takes more than 10 minutes because there are a
> lot of rows. I wonder if I use BCP by copy data to a file and do bulk
> insert from a file, then will it be faster? I 'm not sure because it
> seems like I'm doing 2 steps instead of 1 step via DTS wizard.
> I want to copy data over as fast as possible. Wondering what you guys do
> in my situation.
> thanks
> Kevin
>|||BCP should be faster
I mean try it out see what the time difference is
http://sqlservercode.blogspot.com/
"Kevin" wrote:
> hi guys,
> I have a question about copying a table's data from one server to
> another server. I want the fastest way to do it. basically, I'm using DT
S
> wizard to copy but it takes more than 10 minutes because there are a lot o
f
> rows. I wonder if I use BCP by copy data to a file and do bulk insert from
a
> file, then will it be faster? I 'm not sure because it seems like I'm doi
ng
> 2 steps instead of 1 step via DTS wizard.
> I want to copy data over as fast as possible. Wondering what you guys do
in
> my situation.
> thanks
> Kevin
>
>|||yes, the same network.
but why is your way different from dts or better than DTS?
I don't think it's faster.
"Yosh" <yoshi@.nospam.com> wrote in message
news:eTpbw1EwFHA.1132@.TK2MSFTNGP10.phx.gbl...
> Is the server on the same network? If so, maybe try this:
> INSERT [server].[database].[owner].[table]
> SELECT [columns] FROM [table]
>
> "Kevin" <pearl_77@.hotmail.com> wrote in message
> news:%23O7r4yEwFHA.2864@.TK2MSFTNGP10.phx.gbl...
>|||I thought there are some kinds of table setting I can tweak so I can avoid
transaction log. I know one thing, I can remove indexes to speed up the
copying, but what other tricks do you have?
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:487F4412-7B52-4B5A-A8C4-8B57A6512E15@.microsoft.com...
> BCP should be faster
> I mean try it out see what the time difference is
> http://sqlservercode.blogspot.com/
>
> "Kevin" wrote:
>
Subscribe to:
Posts (Atom)