Moving data from one DB to another DB in SQL Server 2005

20 pts.
Tags:
Data migration
Max_Var_Size
SQL Server 2005
SQL Server 2005 migration
SQL Server migration
Hi all I got formula to calucalate Row_size of a table Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 Fixed_Data_Size = total byte size of all fixed-length columns Variable_Data_Size = 2 + (Num_Variable_Cols x 2) + Max_Var_Size Num_Variable_Cols = number of variable-length columns Max_Var_Size = maximum byte size of all variable-length columns Null_Bitmap = 2 + ((Num_Cols + 7) / 8) some body please explain what is "Max_Var_Size" and If I want move the Data(lets say 10000 row) shall I calucalate the Indexing on the table also? Basically I want calucalate how much data moving from One DB(Sevrer1) to DB(Server2).
ASKED: December 20, 2008  2:22 PM
UPDATED: December 22, 2008  8:22 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Max_Var_Size is the length of the data in the variable length columns.

If you are calculating the size of data then you will want to account for the size of the index.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Snivas
    Hi MrDenny thnanks for replay Max_Var_Size is the length of the data in the variable length columns. if Tables is Vname varchar(50) Vendor_desc varchar(max) Vendor_code nvarchar(50) Vendor_code_desc nvarchar(max) then what is the Max_Var_Size
    20 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following