Cloud computing is the new normal. Every time you are using a service or an application through an internet connection, you are using the cloud. Since most companies nowadays have part or all their databases hosted on the cloud, you ask how is the best way to do it. Migrating your database to the cloud can help you manage your workload by making your data available and easily scalable. Read on to learn about database cloud migration and tips to do it right..
If you have to change the type of a key column on SQL Server, and the new column type has to be integer, and even identity, you can do it by using some criteria in order to get the rows ordered (PK= index clustered= order by in physical disk by this column)..
We will change the type of the PK column of a table in a sample with 2 typical invoice tables master-detail where the key columns are nchar. 'invheader.invoiceid' is the primary key of the master table and 'invlines.lineid' is the primary key of the detail table..