473,513 Members | 2,524 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Moving SQL server to another

17 New Member
Hello,

ive tried a million ways to export objects+data from one server to another.
the MSSQL versions are differant. (the new location is sql2005). When i try to use DTS, i get major problems copy over.. infact it give me a error when trying to copy all objects.. ive tried everything! only way ive copied the tables and stored proc. is by generating scripts using server enterprise. Im still missing the data... i found one program called sql script builder which charges 190!!!!! insane. but anyways it did the job very well, except only 10 rows per table.. very limited on that. can anyone help? thank you!
Aug 13 '08 #1
5 1446
Delerna
1,134 Recognized Expert Top Contributor
I'll be watching this thread with interest.
I assume you are migrating from SQL2000 to SQL2005.
Thats a task I will be engaged in, in the not too distant future.
Aug 13 '08 #2
ck9663
2,878 Recognized Expert Specialist
Can't you do a backup on the sql2000 and restore it sql2005?

-- CK
Aug 13 '08 #3
Betray
17 New Member
Can't you do a backup on the sql2000 and restore it sql2005?

-- CK
The backup files are stored over at the hosts server. I do not have access to these files.
Aug 14 '08 #4
BHTanna
31 New Member
Can't you use sp_attach_db ????
Aug 14 '08 #5
Betray
17 New Member
Can't you use sp_attach_db ????
im unaware of this function.
ive found a slow soloution that copied most of the data over, but 20 tables of data failed. not sure why? no error log
Aug 14 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

4
5479
by: Stephen Ghelerter | last post by:
I am moving a web site with a MySql database to another server. Can I create a database on the new server with the same name and then move the tables there, or is life not that simple? Or can I create tables with no data and then replace them with the files from the other server? I know I can export them as text files and them import them,...
1
2533
by: GuyInTn | last post by:
Hi all, I have been given the task of moving an sql database from one server to another. These servers are not on the same network. I know I can detach the database, copy it to a new location, then FTP it to the new server and re-attach it. My question is, is this the best way to do this? Or is there another way? I have access to both...
2
2060
by: sumGirl | last post by:
Hi all. I know that since you know nothing about my database it will be a stretch to answer this - but does anyone have a boiler plate checklist for moving a database, dts packages, agent jobs, etc...from one server to another? Maybe something that just says I should at least do x,y,z. Also if anyone out there has any hard won...
1
1756
by: barbara | last post by:
We've all data and log files located in SAN mount point. In case of primary server crash, is it possible to unmount the volumes and remount at secondary server? Do we have any problems with master DB moving this way. Detach,attach or backup/restore are not our options. Thanks
5
11431
by: Kay | last post by:
Hello, I have two list boxes on my form, one initially displays with items and the other displays blank, by clicking a button, it is possible to move items from one box to another and vice a versa, this works fine. I also have a dropdown list on the page with autopost back = true, my problem is as follows: when the user selects an option in...
6
1451
by: Woody Splawn | last post by:
I have been using SQL Server 2000 on my stand-alone machine as a back-end to a VS.net application. It is time to switch environments and take the application to the customer. I need to install SQL Server 2000 on the server of the client's local area network, which is a Windows 2000 machine. I am concerned about doing this right. On my own...
3
1932
by: UJ | last post by:
I've got a working web service that we are moving to another machine and now I suddenly get the following error. While transferring the files, got the following message: System.Web.Services.Protocols.SoapException: Server was unable to read request. ---System.InvalidOperationException: There is an error in XML document (1, 1422)....
8
8664
by: rick | last post by:
Hi I m trying to move only stored procedures from one database to another and also onto a database on another server, I tried db2 -x "select text from syscat.procedures where procschema = 'MYSCHEMA'" | tee /esa/home/sasha/MY_SCHEMA_SP.txt, how ever all the procedures are getting loaded to the file but some stored procedures are getting...
1
1375
by: gar598 | last post by:
I don't have much experience moving these types of site, but we're changing sites, and I've been asked to move the site to a new server. It's your typical setup Windows server, ASP.Net 2.0., a few SQL databases. Is there an easy/best way to go about this? Any insight would be most appreciated.
15
2417
by: mcjason | last post by:
I saw something interesting about a grid pair puzzle problem that it looks like a machine when you find each that work out the way it does and say with all the others that work out the way they do together overlapping common pieces but say connected each working out as connected, but together as connected it's connected with the others...
0
7270
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7397
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7565
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7543
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5103
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3255
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3242
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
817
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
473
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.