SQL Server upgrade Problem
-
Hallo All Happy New Year. I run into a big problem. I used for quite a time SQL Server Express Sql non-release 587. Now I would like to migrate the data to another server using sql Express release. Everything I tried did not work. Attaching the database, Backup restoring the database , nothing worked. Always I get an incompatible version error. Is there a tool avaiable like imp/exp in Oracle or mysqldump? Sincerely Chris Vietiane/Laos P.S. I can't use graphical tools or sqlwebadmin. Non of them work with 587 P.P.S. I already contacted Microsoft for this. They say 587 is too old for migration. Only the full SQL Server could do this, not Express. -- modified at 1:25 Tuesday 3rd January, 2006
-
Hallo All Happy New Year. I run into a big problem. I used for quite a time SQL Server Express Sql non-release 587. Now I would like to migrate the data to another server using sql Express release. Everything I tried did not work. Attaching the database, Backup restoring the database , nothing worked. Always I get an incompatible version error. Is there a tool avaiable like imp/exp in Oracle or mysqldump? Sincerely Chris Vietiane/Laos P.S. I can't use graphical tools or sqlwebadmin. Non of them work with 587 P.P.S. I already contacted Microsoft for this. They say 587 is too old for migration. Only the full SQL Server could do this, not Express. -- modified at 1:25 Tuesday 3rd January, 2006
sawat dii bi mai Try an import/export format recognized by both DB engines. For example comma separated values (.csv) or any other format both DB engines understand. Export to a CSV file and then use it to import to the new DB. I'm on-line therefore I am. JimmyRopes
-
sawat dii bi mai Try an import/export format recognized by both DB engines. For example comma separated values (.csv) or any other format both DB engines understand. Export to a CSV file and then use it to import to the new DB. I'm on-line therefore I am. JimmyRopes
sawat dii Jimmy Ropes Sawat di bpii mai duay Chook dii mak kop hkun krap khian jotmai hai pom The problem is that the database is quite complicated. Tons of foreign keys for example. I need a way to extract the structure. Like create table statement e.t.c. I do not have a complete table creation script. Some parts of the application were done by different people. I really need something like mysqldump. I just now try to download Sql Server Eval to the new server in Europe. Microsoft SQL Team sugjested that! Sincerely Chris Vietiane Laos (PDR) P.S. Just now I am in Bangkok (oriental city) So greetings from Bangkok :) Are you in BKK or Thailand just now?
-
sawat dii Jimmy Ropes Sawat di bpii mai duay Chook dii mak kop hkun krap khian jotmai hai pom The problem is that the database is quite complicated. Tons of foreign keys for example. I need a way to extract the structure. Like create table statement e.t.c. I do not have a complete table creation script. Some parts of the application were done by different people. I really need something like mysqldump. I just now try to download Sql Server Eval to the new server in Europe. Microsoft SQL Team sugjested that! Sincerely Chris Vietiane Laos (PDR) P.S. Just now I am in Bangkok (oriental city) So greetings from Bangkok :) Are you in BKK or Thailand just now?
Sawat dii Chris, The export to CSV may still work because when you export the CSV formatted file you can make it copy the Field Names in the first line as the column headers and the following lines are the data that were in those columns. On the file menu select get external data and then import. When you import you can select your own primary key and you will have the same table structure as in the old data base. After all the tables are built you go back to the file menu and select get external data again but this time select Link Tables. You can make the table links from here one at a time. In this way you can preserve the structure of the old data base. If the old DB manager does not allow you to put the field headers in you can do it manually in notepad. If the new data base does not accept CVS format (I think they all do) you can import to a newer version of SQL Server or Access and then export to a format that the new data base engine knows about. chok dii mak krap I live up-country in Issan (North East Thailand). Changwat Buriram, which is in the southern end of Issan and is a border province with Siem Reib - Oddar Meanchey Province in Kampuchea. I do not go to Bangkok very often. I grew up in New York City and do not like big city life very much. A few days at a time are enough to get the things I need and then I am back on the train to Buriram. What part of Bangkok are you staying in? I used to go to ViangChan for three month visas from the Thai embassy but when a border crossing opened up not too far from my house (near KapCheong) about two years ago I find it less expensive to go there every month than to have my wife drive me to NongKhai, stay in ViangChang for three days and then have her drive back to NongKhai to pick me up again. Now that petrol is so expensive the cost is even higher. It costs around 2500 Baht (662,050 Kip) for transport and visa fees to go once a month to KapCheong. If I go to ViangChang it used to cost me around 10,000 Baht (2,648,200 Kip) and that was 2 years ago. The cost will be higher now. When I add up all the expenses by getting 3 one month visas I save around 2500 Baht. In some ways I miss going to ViangChan because it is a small city and I do not mind going there. The last time I was there there was a very big road being built running in front of the Morning Market so it looks like ViangChan was starting to grow but it will probably be a few more years (hopefully many years) before you have traffic jams like Bangkok, Hanoi or HoC
-
Sawat dii Chris, The export to CSV may still work because when you export the CSV formatted file you can make it copy the Field Names in the first line as the column headers and the following lines are the data that were in those columns. On the file menu select get external data and then import. When you import you can select your own primary key and you will have the same table structure as in the old data base. After all the tables are built you go back to the file menu and select get external data again but this time select Link Tables. You can make the table links from here one at a time. In this way you can preserve the structure of the old data base. If the old DB manager does not allow you to put the field headers in you can do it manually in notepad. If the new data base does not accept CVS format (I think they all do) you can import to a newer version of SQL Server or Access and then export to a format that the new data base engine knows about. chok dii mak krap I live up-country in Issan (North East Thailand). Changwat Buriram, which is in the southern end of Issan and is a border province with Siem Reib - Oddar Meanchey Province in Kampuchea. I do not go to Bangkok very often. I grew up in New York City and do not like big city life very much. A few days at a time are enough to get the things I need and then I am back on the train to Buriram. What part of Bangkok are you staying in? I used to go to ViangChan for three month visas from the Thai embassy but when a border crossing opened up not too far from my house (near KapCheong) about two years ago I find it less expensive to go there every month than to have my wife drive me to NongKhai, stay in ViangChang for three days and then have her drive back to NongKhai to pick me up again. Now that petrol is so expensive the cost is even higher. It costs around 2500 Baht (662,050 Kip) for transport and visa fees to go once a month to KapCheong. If I go to ViangChang it used to cost me around 10,000 Baht (2,648,200 Kip) and that was 2 years ago. The cost will be higher now. When I add up all the expenses by getting 3 one month visas I save around 2500 Baht. In some ways I miss going to ViangChan because it is a small city and I do not mind going there. The last time I was there there was a very big road being built running in front of the Morning Market so it looks like ViangChan was starting to grow but it will probably be a few more years (hopefully many years) before you have traffic jams like Bangkok, Hanoi or HoC
Hallo, I am not sure about CSV. My problem is most often the data is held in NTEXT fields. The database consists of articles which are often 100.000 Bytes and more and a lot of binary data like images. I guess it will be very difficult exporting with CSV. Maybe I have to write an own exporter. What a shame. And I have hundreds of tables. :doh: You know already the most important fact of live. Beer Lao or also named Bia Lao is the best beer in the world. :) Some information about myself. I permanetly travel between Vietiane, Chayaphum and Bangkok, so I have 3 places to stay. My Company has offices in Bangkok and Vietiane. I am married with a Laos Lady originally from Sam Nuea. I just returned today from the Immigration Department in Sathorn Dai to extend my Thai Visa. Maybe we should have a Beer in Buriram. Actually I will travel to Buriram (I have a customer there) within the next two weeks. I have to, the customer is already complaing. :( Sincerely Chris -- modified at 3:07 Wednesday 4th January, 2006
-
Hallo, I am not sure about CSV. My problem is most often the data is held in NTEXT fields. The database consists of articles which are often 100.000 Bytes and more and a lot of binary data like images. I guess it will be very difficult exporting with CSV. Maybe I have to write an own exporter. What a shame. And I have hundreds of tables. :doh: You know already the most important fact of live. Beer Lao or also named Bia Lao is the best beer in the world. :) Some information about myself. I permanetly travel between Vietiane, Chayaphum and Bangkok, so I have 3 places to stay. My Company has offices in Bangkok and Vietiane. I am married with a Laos Lady originally from Sam Nuea. I just returned today from the Immigration Department in Sathorn Dai to extend my Thai Visa. Maybe we should have a Beer in Buriram. Actually I will travel to Buriram (I have a customer there) within the next two weeks. I have to, the customer is already complaing. :( Sincerely Chris -- modified at 3:07 Wednesday 4th January, 2006
I think you are probably right that CSV format would not be able to handle BLOB data. I didn't know the nature of your data when I recommended CSV. My suggestion was meant to alert you to the possibility that if you can not take the direct route sometimes there are other things you can try. Before you ship your data off to Europe it may be worth taking a look at the other formats available from the old DB engine. Then again, by shipping the data off to a contractor you will not have to deal with the problems that come up whenever you try to do things that are not meant to be done. ============================================ In my heart of hearts I know what you are saying about Bia Lao is true but I can't be saying that around here. In Issan Beer Chang rules! Not the Carlsberg knockoff, Singha, but Beer Chang is the only beer sold in the village. Of course, in Muang Buriram you can get Singha or even Carlsberg but here in BanLaBerg (you say you have never heard of BanLaBerg - it is also known as Nakhon Nowhere) we have a tradition to uphold. The local variety of Lao Cal, Sam Sung (Thai wiskey) and Beer Chang are the only alcoholic drinks you can buy here. I even have to go to the next village, BanPrasat to buy Regency (Thai Brandy) but it is very close, maybe 1 Km from my house to the store in BanPrasat, so it is not all that bad. I am surprised that you even know where Buriram is let alone that you actually come here. Let me know when you will be in town and we can meet and have a drink. I never thought I would ever meet anyone from the Code Project before. It is a small world. I'm on-line therefore I am. JimmyRopes