473,385 Members | 1,324 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Moving objects from 1 SQL Server to another

10
Greetings one and all,

I hope some here can help me.

We are currently running SQL Server 2000 on 2 different servers. The first server was an upgrade from SQL 7 so the data, etc are in a directory named MSSQL7. The second sever is newer and larger (Disk and Memeory) and was a straight install, so the data is in MSSQL.

I am trying to move everything from the old server to the new one. The databases are easy as well as the users. I can not get my DTS packages, DB Maintenance, and SQL Server Agent jobs from the old one to the new one.

Any ideas?? We are running out of room on the old server and need to get this moved over asap.

I look forward to hearing from someone.

Ray
Sep 11 '06 #1
2 3668
MrByte
4
For the SQL Server Agent jobs (and DB Maintenance as well, as they are all created as Jobs I believe) you can right click in the Enterprise Managers Management/Jobs Tree and select All Tasks/Generate SQL Script

Hope this helps.


Greetings one and all,

I hope some here can help me.

We are currently running SQL Server 2000 on 2 different servers. The first server was an upgrade from SQL 7 so the data, etc are in a directory named MSSQL7. The second sever is newer and larger (Disk and Memeory) and was a straight install, so the data is in MSSQL.

I am trying to move everything from the old server to the new one. The databases are easy as well as the users. I can not get my DTS packages, DB Maintenance, and SQL Server Agent jobs from the old one to the new one.

Any ideas?? We are running out of room on the old server and need to get this moved over asap.

I look forward to hearing from someone.

Ray
Sep 11 '06 #2
rdfanta
10
Mr Byte,

Thanks for the info. The only Item that gives me that option is the SQL Server Agent Jobs. But I get an error when trying to run the script because the DB Maintenance Job does not exist.

For the DTS Packages, I am trying to save them as Structured Storage files or Visual Basic files. But I have not figured out how to read them back in

Ray
Sep 13 '06 #3

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

Similar topics

11
by: Michal Migurski | last post by:
Hi everyone, I've been planning to move to Python from PHP for some time now. I use PHP extensively for web scripting, with mod_php, Apache, and a DB (I would characterize my knowledge of PHP as...
4
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...
1
by: Tom Loach | last post by:
I have user that we just migrated his Access database to SQL Server. All went well with the migration, but then he came up with another requirement to be able to replicate the database to a local...
2
by: bryja_klaudiusz[at]poczta[dot]fm | last post by:
Hi, How to copy database diagram (all data) to other server using only MSDE server and VS.Net Proffesional? I have no Enterprice manager. I have to move database (create on my machine) to my...
4
by: Ron Mexico | last post by:
Hi, Currently have an app that maintain that is written in VB6 and uses an access db (backend db only used as a data store not writing to the db). This app is a client app not server multi-teir...
3
by: John South | last post by:
Hi I've developed a web service that allows people to easily set-up their own websites, and keep them up-to-date themseves. It's all done in standard ASP and SQL 2000. You can see it here: ...
1
by: Goutour | last post by:
Hello, I am a 2-day old Javascript developer :-) and I have a problem. I am trying to do examples I find on net about using onmouse events. I found a javascript that generates flying objects, and I...
15
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...
5
by: Betray | last post by:
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

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.