question

Elysian avatar image
Elysian asked

To transfer SQL server table from one database to other without downtime

Please let me know if there is a way to transfer 100 GB table of a database to another database(same instance) without downtime

If possible please give me solution other than export import

@WRBI

sql serverdatabase
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·

Define "downtime". Is this from an application perspective or SQL? Switching a partition is about the fastest way to move data but you can't cross databases with that. Even then it might be a few seconds to make that switch.

1 Like 1 ·
WRBI avatar image WRBI commented ·

Just some random thoughts:

Would snapshot/transactional replication be an option? It wouldn't stop data going into the the table. It can be put the system under a lot of pressure though.

Could you use a backup and take the one table and move the data from there instead?

Is the purpose to use the new table in production or just for testing etc. if you've got a period of time outside of normal office hours, you could move it during that time

0 Likes 0 ·
JohnM avatar image JohnM WRBI commented ·

Replication/Mirroring might be a good solution depending on what 'downtime' means to the OP.

1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.