Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nanygadu14
Starting Member
2 Posts |
 Posted - 2008-04-23 : 10:50:10
|
| Hi ....In my project i got stuck at the migration point,I want to migrate the data from 2000 to 2005 sql server.I want to migrate the data with indexes,procedures...Please help me in solving this problem.... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 11:45:58
|
| Is it specific table or whole database?1)You can use backup.restore2)use export.import wizard for tables or bcp |
 |
|
|
nanygadu14
Starting Member
2 Posts |
Posted - 2008-04-28 : 07:12:40
|
| Yeah its a complete Database |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-28 : 09:02:10
|
quote:
Originally posted by nanygadu14
Yeah its a complete Database
Backup the database from SQL Server 2000 and restore it on SQL Server 2005MadhivananFailing to plan is Planning to fail |
|
|
|
sterlien
Starting Member
3 Posts |
Posted - 2008-05-06 : 10:32:50
|
| I have a simialr issue but I am copying from 2000 to 2005 and the 2005 is a remote host (a shared hosting account with Godaddy.com) GoDaddy says that I am not able to use the SQL Server restore feature to import a .bak file that came from a database outside of their system.So the source is using a sql server 2000 db sitting on a local server. We want to make a copy of the db on godaddy.com. I tried to copy over the data one table at a time but I ran into an error for a larger table that contains html pages within the cells. I think the code should all be on 1 line but most of it is not. I keep getting error messages like "Line 2 has 3 values. (13 expected)"What is your suggestion for getting a copy of my data over to the remote host? I was successful in getting the objects over to the remote host and a few smaller tables but not the MAIN table.Also, do you know if you can select a destination server that is outside the network?Please help! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 21:29:48
|
| You may zip the file than transfer it. To query from remote server, can create linked server if have connection in between. |
|
|
|
|
|
|
HELP::Export data from 2000 to 2005