SQL Server 2005de Çalıştırılabilen DATABASE'nin 2000de Çalışmasını nasıl sağlarım ?

  Merhaba;

Bu islem düsünüldügü kadar kolay degil kabaca yapilmasi gereken isler.

1- Tablolari sql 2000 e tek tek tasimaniz gerekiyor.

2- Tüm key ler yeniden tanimlanmali

3- Tüm index ler yeniden olusturulmali

Ben açikcasi henüz bir programi tümü ile tasimis herhangi bir örnek bilmiyorum

Fakat size bu isi yapmak için yardim alan bir arkadasima yazdigim notlarida iletyorum.

1- Tablolari sql 2000 e tasima ekran görüntüsü= 

Table ekran tasima ekran görüntüsü. http://www.cozumpark.com/cpekip/SQL/2000_db.rar

 

2-Ilgili anahtarlari görmek için su komutu kullanabilirsiniz .

EXEC sp_MStablerefs [tbfirma]

ÖNCESINDE VE SONRASINDA IKI DB DE MUTLAKAK TABLE LISTE ALIN...

tavsiyem query de kolay görebileceginiz bu sql kullanabilirsin obje tiplerinin listesi de asagida bulabilirsin.

 

EXEC SQL2005.dbo.sp_tables

SELECT * FROM sysobjects WHERE (xtype = 'TR') --TR obje tipini gösterir

 --oBJE LISTESI

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

L = Log

FN = Scalar function

IF = Inline table-function

P = Stored procedure

R = Rule

PK = PRIMARY KEY constraint (type is K)

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

UQ = UNIQUE constraint (type is K)

V = View

X = Extended stored procedure  

 

Bu arada size önerim sql2005 kesinlikle sql2000 den daha avantajli performans ve gerek yönetimi ile size tavsiyem ögrenmeniz.

Yeni bir versiyondan bilmedginiz için eski versiyon tercihi bana yanlis geliyor bence egitim dökümleri paylasilan forumlar var burada onlardan yardim alip kendinizi egitebilirsiniz veya bi kursa gidebilirsiniz.

iyi günler.

 

 

  Merhaba;

Bu islem düsünüldügü kadar kolay degil kabaca yapilmasi gereken isler.

1- Tablolari sql 2000 e tek tek tasimaniz gerekiyor.

2- Tüm key ler yeniden tanimlanmali

3- Tüm index ler yeniden olusturulmali

Ben açikcasi henüz bir programi tümü ile tasimis herhangi bir örnek bilmiyorum

Fakat size bu isi yapmak için yardim alan bir arkadasima yazdigim notlarida iletyorum.

1- Tablolari sql 2000 e tasima ekran görüntüsü= 

Table ekran tasima ekran görüntüsü. http://www.cozumpark.com/cpekip/SQL/2000_db.rar

 

2-Ilgili anahtarlari görmek için su komutu kullanabilirsiniz .

EXEC sp_MStablerefs [tbfirma]

ÖNCESINDE VE SONRASINDA IKI DB DE MUTLAKAK TABLE LISTE ALIN...

tavsiyem query de kolay görebileceginiz bu sql kullanabilirsin obje tiplerinin listesi de asagida bulabilirsin.

 

EXEC SQL2005.dbo.sp_tables

SELECT * FROM sysobjects WHERE (xtype = 'TR') --TR obje tipini gösterir

 --oBJE LISTESI

C = CHECK constraint

D = Default or DEFAULT constraint

F = FOREIGN KEY constraint

L = Log

FN = Scalar function

IF = Inline table-function

P = Stored procedure

R = Rule

PK = PRIMARY KEY constraint (type is K)

RF = Replication filter stored procedure

S = System table

TF = Table function

TR = Trigger

U = User table

UQ = UNIQUE constraint (type is K)

V = View

X = Extended stored procedure  

 

Bu arada size önerim sql2005 kesinlikle sql2000 den daha avantajli performans ve gerek yönetimi ile size tavsiyem ögrenmeniz.

Yeni bir versiyondan bilmedginiz için eski versiyon tercihi bana yanlis geliyor bence egitim dökümleri paylasilan forumlar var burada onlardan yardim alip kendinizi egitebilirsiniz veya bi kursa gidebilirsiniz.

iyi günler.

 

 

Öncelikle ilginize tesekkür ederim.Fakat açikca sölemek gerekirse anlattiklarinizdan pek birsey anlamadim çünkü sql bilgim çok az.Sql 2005 ögrenmeye çalisiyorum kendi çapimda fakat çok sinirlerimi bozdu :).Dünden beri db'i yedeklemeye (backup) yapmaya çalisiyorum fakat beceremedim.(biliyorsaniz izah edermisiniz ?).Ekleme : backup edebildim sonunda (: , didikleye didikleye boza boza ögrenmeye çalisiyorum.Ekleme 2 : Rica edersem imkani olan biri link'ini verdigim database'nin 2000'e uyarlanmis versiyonunu benimle paylasabilir mi?Gerçekten çok ugrastim Hatice AKGUL ablamin dedikleri dogrultusunda yapmaya fakat beceremedim.Gerçekten bunun 2000 versiyonuna ihtiyacim var çünkü suan islerim hiç yürümüyor ve 2005'i ögrenmem biraz zaman alacak.Tekrar rica etsem aramizdan biri bu iyiligi yapabilirmi?Sizlere simdiden tesekkür ederim ilgi gösterdiginiz için.

Not : Yapabilirim diyen biri çikarsa ö.m ile iletisime geçerse link veririm.Gerçekten acil ve yardiminiza çok ihtiyacim var.

Bu arada neden acilen ihtiyacım olduğunu açıklamak isterim.Şahsım adına bir dedicated kiraladım ve bir oyunun privatesini yönetmeye hazırlanıyorum.Bunun detayına girmeme gerek yok.Dedicated'te SQL 2000 kurulumuna izin var.Kaldıki SQL 2005 kurulumuna izin verseler dahi pek birşey bilmediğimden verim alamıyacağım ve param boşa gidecek.Bende bir lise 2 öğrencisi olduğuma göre çöpe atacak param yok :).Ayrıca database'i düzenlemem için gerekli olan edit programları SQL 2005'de çalışmıyor.Bu kadar açıklama yeterli olacaktır sanırım.

Tekrarlıyorum yardım edecek olan abilerim ablalarım ö.m ile iletişime geçerlerse database'nin linkini verebilirim.

Merhaba,

DB ilk açıldığında SQL 2005 üzerinde açılmışsa, yani db level 2005 ise bunu SQL Server 2000 üzerine taşıyamazsınız.

DB ilk açıldğında 2000 üzerindeyken, sonrasında 2005 e upgrade olmuşsa bunu eskisi gibi 2000 de kullanabilirsiniz.

2005 level bir db deki veriler için ise table ların export edilip, 2000 e import u yapılabilir, yukaarıda açıklandığı gibi. (işinizi görecekse)

2000 den upgarede olan 2005 db için ise aşağıdaki yöntem kullanılabilir.

How to Downgrade a Database from SQL Server 2005 to SQL Server 2000

 

As you may all know, SQL Server 2005 request a minimum of 8GB RAM to work… let say satisfactorily. I first didn’t knew that and after a while from the upgrade I did from SQL Server 2000 to 2005 my SQL Services were starting to crash three or four times per DAY!!!

 

At first I thought I was being attacked, but soon I realized it was nothing like that. I then decided to downgrade to an SQL Server 2000 edition. Though I looked around the internet to find some information on how to do that, I got very disappointed when I realized that no actual documentation of any kind could be found for that. So I am posting this thread to inform you on the procedures I had to follow for this action.

 

Before beginning I must assume, firstly that the user, who will attempt such thing, has  a basic knowledge of SQL Environment, secondly that he has the two versions already installed (both 2000 and 2005), that a basic backup of the databases has been created and finally that all the 2005 SQL Server Users have been created at the SQL Server 2000 environment as well.

 

Step 1 Generating Scripts for the Database Elements and Structures

 

1)      Right-click over the desired Database at 2005, Choose Tasks and the Generate Scripts (Option).

2)      At the pop-up Dialog Box click at the Script All Objects in the selected Databases check box, to activate it and then Click the Next Button.

3)      Set the following Elements to the following Values

a.       Script Collation , set to TRUE

b.      Script Database Create, set to TRUE

c.       Script of SQL Version, set to SQL SERVER 2000

d.      Script foreign keys, set to FALSE

e.       Script Triggers, set to FALSE

 Then Hit the Next button

4)      Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.

5)      Click Finish

 

After completing this procedure, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Structure of the Database will be created.

 

Be careful, the SQL Server 2005 Edition inserts the Views in a random place through the script. Therefore, all the scripts that are referred to the Views MUST be moved to the end of the script. If the Query Analyzer shows some errors do not be bothered. Delete all the elements created from the script and after you fix the code run it again.

 

 

Step2 Moving the data from 2005 to 2000

 

1)      After completing the previous step successfully, moving the data follows. Right-click at the 2005 database you used to run the previous step and select Tasks and then choose the Export Data (option).

2)      From the pop-up Dialog Box, select the Source Db and Click at the Next Button.

3)      At the next step you will have to choose the destination server and the destination Database for the Data to be exported. Then Click Next.

4)      A List of all the Source Database’s Elements will appear in the screen. Select one by one all the Elements you wish to move and for each one click at the button Edit Mappings (Located at the bottom right corner of the Dialog Box just under the Elements list). A new Dialog box will pop-up. Select the Delete rows in Destination Tables option and activate the Enable Identity Insert Option. (Remember to repeat this action for each of the selected Element from the list that will be moved.

 

CAUTION!!! A malfunction of the SQL Server 2005 has been found. Not sure why, after multiple tries I have observed that when I tried to move more than twelve Elements at once, the Export Data Wizard of SQL Server 2005 seemed to disable the Enable Identity Insert Option that was activated over the Edit Mappings Dialog Box. But if the number of the selected Elements is smaller than 12 no problem seemed to appear.

 

Step 3 Generating Scripts for the Database Foreign Keys and Triggers

 

Finally, to successfully finish the downgrade of the Database, the Triggers and the Foreign Keys of the DB must be produced. The procedure that should be followed is the one stated next:

 

1)      Right-Click at the SQL 2005 Database and Select from Tasks Menu the Generate Scripts Option.

2)      Using the pop-up Dialog Box make sure that the check box Script All Objects in the selected Databases is not enabled and hit the Next Button.

3)      Set all the Elements on the List to a False Value except the ones that follow:

a.       Include IF NOT EXISTS , set to TRUE

b.      Script Owner, set to TRUE

c.       Script of SQL Version, set to SQL SERVER 2000

d.      Script foreign keys, set to TRUE

e.       Script Triggers, set to TRUE

 Then Hit the Next button

4)      After finishing reading the Elements of the Database, a new list will appear at the Dialog Box. Make sure that you select ONLY THE TABLES of the Database and hit the Next Button.

5)      At the screen that follows hit the Select All button and the Next.

6)      Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.

7)      Click Finish Button.

 

After completing this procedure, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Foreign Keys and the Triggers of the Database will be created.

 

After these steps the database should be fully functional under the SQL Server 2000 edition.

 

www.hellasinternet.com

Panos Tzirakis & George Dounavis

 

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e

 

Merhaba,

DB ilk açıldığında SQL 2005 üzerinde açılmışsa, yani db level 2005 ise bunu SQL Server 2000 üzerine taşıyamazsınız.

DB ilk açıldğında 2000 üzerindeyken, sonrasında 2005 e upgrade olmuşsa bunu eskisi gibi 2000 de kullanabilirsiniz.

2005 level bir db deki veriler için ise table ların export edilip, 2000 e import u yapılabilir, yukaarıda açıklandığı gibi. (işinizi görecekse)

2000 den upgarede olan 2005 db için ise aşağıdaki yöntem kullanılabilir.

How to Downgrade a Database from SQL Server 2005 to SQL Server 2000

 

As you may all know, SQL Server 2005 request a minimum of 8GB RAM to work… let say satisfactorily. I first didn’t knew that and after a while from the upgrade I did from SQL Server 2000 to 2005 my SQL Services were starting to crash three or four times per DAY!!!

 

At first I thought I was being attacked, but soon I realized it was nothing like that. I then decided to downgrade to an SQL Server 2000 edition. Though I looked around the internet to find some information on how to do that, I got very disappointed when I realized that no actual documentation of any kind could be found for that. So I am posting this thread to inform you on the procedures I had to follow for this action.

 

Before beginning I must assume, firstly that the user, who will attempt such thing, has  a basic knowledge of SQL Environment, secondly that he has the two versions already installed (both 2000 and 2005), that a basic backup of the databases has been created and finally that all the 2005 SQL Server Users have been created at the SQL Server 2000 environment as well.

 

Step 1 Generating Scripts for the Database Elements and Structures

 

1)      Right-click over the desired Database at 2005, Choose Tasks and the Generate Scripts (Option).

2)      At the pop-up Dialog Box click at the Script All Objects in the selected Databases check box, to activate it and then Click the Next Button.

3)      Set the following Elements to the following Values

a.       Script Collation , set to TRUE

b.      Script Database Create, set to TRUE

c.       Script of SQL Version, set to SQL SERVER 2000

d.      Script foreign keys, set to FALSE

e.       Script Triggers, set to FALSE

 Then Hit the Next button

4)      Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.

5)      Click Finish

 

After completing this procedure, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Structure of the Database will be created.

 

Be careful, the SQL Server 2005 Edition inserts the Views in a random place through the script. Therefore, all the scripts that are referred to the Views MUST be moved to the end of the script. If the Query Analyzer shows some errors do not be bothered. Delete all the elements created from the script and after you fix the code run it again.

 

 

Step2 Moving the data from 2005 to 2000

 

1)      After completing the previous step successfully, moving the data follows. Right-click at the 2005 database you used to run the previous step and select Tasks and then choose the Export Data (option).

2)      From the pop-up Dialog Box, select the Source Db and Click at the Next Button.

3)      At the next step you will have to choose the destination server and the destination Database for the Data to be exported. Then Click Next.

4)      A List of all the Source Database’s Elements will appear in the screen. Select one by one all the Elements you wish to move and for each one click at the button Edit Mappings (Located at the bottom right corner of the Dialog Box just under the Elements list). A new Dialog box will pop-up. Select the Delete rows in Destination Tables option and activate the Enable Identity Insert Option. (Remember to repeat this action for each of the selected Element from the list that will be moved.

 

CAUTION!!! A malfunction of the SQL Server 2005 has been found. Not sure why, after multiple tries I have observed that when I tried to move more than twelve Elements at once, the Export Data Wizard of SQL Server 2005 seemed to disable the Enable Identity Insert Option that was activated over the Edit Mappings Dialog Box. But if the number of the selected Elements is smaller than 12 no problem seemed to appear.

 

Step 3 Generating Scripts for the Database Foreign Keys and Triggers

 

Finally, to successfully finish the downgrade of the Database, the Triggers and the Foreign Keys of the DB must be produced. The procedure that should be followed is the one stated next:

 

1)      Right-Click at the SQL 2005 Database and Select from Tasks Menu the Generate Scripts Option.

2)      Using the pop-up Dialog Box make sure that the check box Script All Objects in the selected Databases is not enabled and hit the Next Button.

3)      Set all the Elements on the List to a False Value except the ones that follow:

a.       Include IF NOT EXISTS , set to TRUE

b.      Script Owner, set to TRUE

c.       Script of SQL Version, set to SQL SERVER 2000

d.      Script foreign keys, set to TRUE

e.       Script Triggers, set to TRUE

 Then Hit the Next button

4)      After finishing reading the Elements of the Database, a new list will appear at the Dialog Box. Make sure that you select ONLY THE TABLES of the Database and hit the Next Button.

5)      At the screen that follows hit the Select All button and the Next.

6)      Select the way the generated scripts should be saved (There are different selections. The most common one is Clipboard). Finally click the Next button till you reach the end.

7)      Click Finish Button.

 

After completing this procedure, we have to move to the SQL SERVER 2000 environment. Here, by using the Query Analyzer, we will have to run the scripts that were generated using the master database. Copy and Paste the script at the Query Analyzer and run it. After that the Foreign Keys and the Triggers of the Database will be created.

 

After these steps the database should be fully functional under the SQL Server 2000 edition.

 

www.hellasinternet.com

Panos Tzirakis & George Dounavis

 

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e

 

Yardımınız için teşekkür ederim,sorun çözülmüştür.