Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Microsoft Related >> ASP.NET
  2. Suggest New Category

How to migrate from sqlserver 2005 to sql server 2000
(every one know reverse process of that )

Question Posted / venu

Answer Posted / venu

During the process of migrating to SQL Server 2005, many
development organizations will still be forced to support
SQL Server 2000 installations. As a result, a common
requirement is the ability to reverse-migrate: move
databases back from SQL Server 2005 to SQL Server 2000.

Unfortunately, this is not as easy. Backed-up databases from
SQL Server 2005 instances cannot be restored in SQL Server
2000 instances. Nor can detached SQL Server 2005 databases
be reattached to SQL Server 2000.

Because backup/restore and detach/attach are not supported,
the only methods available for moving data from SQL Server
2005 installations to SQL Server 2000 installations are
based on copying data. Data and schemas can be scripted
using a tool such as Red Gate's SQL Packager and scripts can
be applied on the SQL Server 2000 installations. Another
option is to use tools such as DTS or SSIS, both of which
include data copying wizards.

However, copying data and schema is a potentially
troublesome experience. SQL Server 2005 supports many
features that are not present in SQL Server 2000 and can
cause problems during cross-migration. It's important to be
cautious when attempting to develop solutions for both
platforms, and my recommendation is that development should
be done using SQL Server 2000 and the code and data migrated
forward to SQL Server 2005, rather than the other way around.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is marshalling ? Is it a part of asp.net ?

1138

What are the Types of state management techniques

1064

Define msil.

1013

How is session id generated?

980

What is user control in asp.net?

1142

What is sql data source control in asp.net?

1094

Give some salient points of difference between request processor and request dispatcher.

1104

How will create assesblies at run time?

1034

List the major built-in objects in asp.net?

1046

What is the life-span of the items in the viewstate?

992

Define resource files.

1014

What is the concept of postback in asp.net?

1078

What is asp.net and ado net?

1055

What is cookies in asp net?

988

How does cookies work in asp net?

1117