Showing posts with label copy. Show all posts
Showing posts with label copy. Show all posts

Thursday, March 29, 2012

Alternate Methods of Exporting Data?

Hi all,
I have been fighting with the Copy SQL Server Objects task for a couple of
days. I have been trying to copy an entire database. I am trying to set
the Destination Database name dynamically ( I have used the Dynamic
Properties Task, Code, etc...)
Nothing works. I am continually prompted with an error that states that the
database is not in the databases collection. Of course not, it hasn't been
created yet...that's what the export is supposed to do and no matter of
Googling on the error has helped.
Anyone have any clues or suggestions for alternative ways to copy an entire
database AND provide the name dynamically for it?If this is a one time task, you could restore a backup copy of the database.
If you need to continually copy data you could look into both replication
and log shipping.|||Sorry, I didn't read your question carefully.
"Bianca Blount" <blountb@.noemail.com> wrote in message
news:u8OYoDWqDHA.976@.tk2msftngp13.phx.gbl...
> If this is a one time task, you could restore a backup copy of the
database.
> If you need to continually copy data you could look into both replication
> and log shipping.
>

Sunday, March 25, 2012

Alter table with merge replication

Hello,
We are using sql2000.
1.Is there a better way to change field data type with
merge replication than add column, copy data and then drop
column?
2.How can i create index with merge replication?
3.If the only way is stop and restart the replication,
what is the easiest way to do so?
Many Many Thanks For Reply.
>
> We are using sql2000.
> 1.Is there a better way to change field data type with
> merge replication than add column, copy data and then drop
> column?
No, there isn't. You use sp_repladdcolumn to add the new column and then
sp_repldropcolumn to remove the old column. Note that ALTER TABLE and ALTER
COLUMN does this transparently.

> 2.How can i create index with merge replication?
>
You use the @.schema_option argument of the sp_repladdcolumn to generate a
corresponding index. A value of 0x010 will generate a clustered index and
0x40 will generate a nonclustered index.

> 3.If the only way is stop and restart the replication,
> what is the easiest way to do so?
You don't need to break merge replication to perform make schema changes in
SQL Server 2000.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

Alter table with merge replication

Hello,
We are using sql2000.
1.Is there a better way to change field data type with
merge replication than add column, copy data and then drop
column?
2.How can i create index with merge replication?
3.If the only way is stop and restart the replication,
what is the easiest way to do so?
Many Many Thanks For Reply.>
> We are using sql2000.
> 1.Is there a better way to change field data type with
> merge replication than add column, copy data and then drop
> column?
--
No, there isn't. You use sp_repladdcolumn to add the new column and then
sp_repldropcolumn to remove the old column. Note that ALTER TABLE and ALTER
COLUMN does this transparently.
> 2.How can i create index with merge replication?
>
--
You use the @.schema_option argument of the sp_repladdcolumn to generate a
corresponding index. A value of 0x010 will generate a clustered index and
0x40 will generate a nonclustered index.
> 3.If the only way is stop and restart the replication,
> what is the easiest way to do so?
--
You don't need to break merge replication to perform make schema changes in
SQL Server 2000.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.