July 12, 2008 at 4:52 pm
Hello,
I have SQL Server 2000.
A DBA has sent me SQL Server 2005 Express edition mdf and ldf files. I don't seem to be able to bring them into SQL 2000.
Can I download SQL Server 2005 Express onto the same XP Professional machine? Can SQL Server 2000 and SQL Server 2005 Express edition reside on same pc?
Is this the best way to read their files?
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
July 12, 2008 at 5:04 pm
tony,
SQL Server Express 2005 is the same as SQL Server 2005 for database formats, so SQL 2000 won't work.
You could install SQL Server 2005 Express as a named instance on your SQL 2000 box, with no issues, and then attach the database that way.
Or if you're worried, grab Virtual Server and setup a VM, install SQL Server 2005 Dev or Express there to work with the files.
July 13, 2008 at 7:21 am
installing sql2005 express should be no more than if you were installing another sql2000 instance.
Install a named instance and then remove it when you're done if you want to
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2008 at 1:10 pm
If memory servers me correctly, SQL Express will install with a default instance name of machine name\SQLEXPRESS, and yes have installed it on a box that had SQL 2000 installed. One advantage SSMS will access both your Express and 2000 instances.
July 19, 2008 at 5:35 pm
Hi,
Thanks for all the help from everyone.
The only problem is that with SQL Server 2000, I did A LOT of DTS work. Stored procedures and DTS was the bulk of my work.
Now that I have downloaded SQL Express Edition, I don't see DTS. I guess that now it is called SSIS. However, I don't see that.
Am I right is assuming that SSIS is not available in the Express Edition?
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
July 20, 2008 at 11:43 pm
[font="Verdana"]Stored procedures are stored in user databases and hence once you attached the db you will get all the sp's.
For DTS, SQL Server stores these packages in MSDB database and hence to retrive it you need the old backup (SQL 2000) of MSDB db. [/font]
Regards..Vidhya Sagar
SQL-Articles
July 21, 2008 at 10:49 am
Actually the question was can I do DTS / SSIS work with SQL Server 2005 Express?
Things will work out. Get back up, change some parameters and recode.
July 22, 2008 at 5:50 am
If you want to edit your DTS packages through the SQL Express Management Studio then you can access them through Management > Legacy > Data Transformation Services when you connect to your SQL instance. However, you also have to install the SQL Server 2000 DTS Designer Components on your client which are available here (do a find for DTS)
July 22, 2008 at 5:54 am
Forgot to mention something ...
With the SQL 2000 DTS Designer Components, when you're editing a DTS package you won't be able to do anything else in Mgmt Studio (it all seems to freeze). Also I find that certain actions you can't do on your keyboard (e.g. select a task and then press delete to get rid of the task - you'll have to right-click and select delete from the context menu).
Once you get over the limitations then it works OK, but I think some of these flaws might have been left in there to encourage people to migrate their DTS packages to SSIS! :rolleyes:
July 22, 2008 at 2:49 pm
Awesome!!
That is exactly what I needed. Hopefully these tools allow you not only read legacy DTS packages, but actually create new ones.
I will ask the boss to buy SQL Server 2005 once I figure out the cost (sizing, cost of licenses, wht's need now, what's future planning, etc.) Then I will begin using SSIS.
I wish I could have given you some points.
Thanks again.
Things will work out. Get back up, change some parameters and recode.
July 23, 2008 at 1:39 am
Ah if you want to create new ones then that's another limitation. One way I've found of getting around this though is by editing an existing DTS package and deleting all its contents then doing Save As... (very important that bit to ensure you don't overwrite your old DTS package) and saving it as a template file. Then for any new DTS packages you just edit your Template package and then do another Save As... and call the package whatever you want.
July 23, 2008 at 9:19 am
Perry Whittle (7/13/2008)
installing sql2005 express should be no more than if you were installing another sql2000 instance.Install a named instance and then remove it when you're done if you want to
If you install SQL 2000, then 2005, then decide to remove 2005....you probably will wind up uninstalling 2000 and reinstalling it.
Same thing if you install a 2008 beta and uninstall it.
If you just want this to be a temporary thing, a virtual machine is the way to go.
July 23, 2008 at 1:58 pm
If you do not want to spend many $$$ for SQL 2005 ... try using the DEVELOPER version.... available from Amazon for 45 to 50 USD depending on what delivery (express or normal) service you request.
July 23, 2008 at 7:38 pm
Phil,
That would be an awesome idea. I could still "develop" DTS packages but using SQL Server Express Edition.
The only problem is that I tried what you said. I went to management,but I don't see "legacy". All I see is SQL Server logs.
Is there an Add-on that I need to download to show me the legacy DTS packages?
Is there a ADD-ON download to download SSIS for SQL Server Express?
Thanks a lot.
Things will work out. Get back up, change some parameters and recode.
July 23, 2008 at 7:47 pm
Thanks BitBucket,
I've never heard of SQL Server Developer and I need to look into that. If I can't develop DTS packages (through this legacy link) in SQL Server Express Edition and I can't add-on SSIS to SQL Server Express, the definitely the Developer edition is the way to go.
Thanks for the suggestion and I will look into it some more.
Things will work out. Get back up, change some parameters and recode.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply