By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,702 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,702 IT Pros & Developers. It's quick & easy.

Converting INT datatype to BIGINT datatype

P: n/a
HI,

I have a table with IDENTITY column with the datatype as INTEGER. Now
this table record count is almost reaching its limt. that is total
record count is almost near to 2^31-1. It will reach the limit with in
another one or two months.

In order to avoid the arithmentic overflow error 8115, we would like
change the datatype from INT to BIGINT. we hope this will solve our
problem.

How do I approch this datatype conversion?. Since the data count is
huge, that leads to a long down time of database.

we need better approach or solution for this problem?. kindly give me
a better solution that will reduce the total downtime of the production
database.?.

Regards

Dec 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Please don't multi-post. I answered this in the MS newsgroups.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Praveen" <ap****@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...
HI,

I have a table with IDENTITY column with the datatype as INTEGER. Now
this table record count is almost reaching its limt. that is total
record count is almost near to 2^31-1. It will reach the limit with in
another one or two months.

In order to avoid the arithmentic overflow error 8115, we would like
change the datatype from INT to BIGINT. we hope this will solve our
problem.

How do I approch this datatype conversion?. Since the data count is
huge, that leads to a long down time of database.

we need better approach or solution for this problem?. kindly give me
a better solution that will reduce the total downtime of the production
database.?.

Regards

Dec 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.