|
Hi,
I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64.
The old server runs SQL Server 2000, SQL Server 2005 and SQL Server 2008. I ...
Started by ArnieZ on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at serverfault):
Thought of using virtualisation?
I had to deal machine it would need to rewrite the database files in the SQL 2000 format so that the SQL 2000 server....
Won't be able to restore it to a SQL 2000 server.
|
|
I have a SQL Server 2000 database backup, but I don't have SQL Server 2000 installed. I have SQL Server 2005 installed. I'd like not to have multiple pieces of DB server software installed. Is it possible in either SQL Server 2005 or SQL Server 2008 to...
Started by BenAlabaster on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
That means that a SQL Server 2005 SP1 will not be able to 'host' a database of version SQL Server 2005 RTM, nor one SQL Server to upgrade from....
Own database format, and the format changes from version to version .
|
|
I have the same question to ask, but I'm using both SQL 2000 Server .
When the table1 in SQL Server 2000 gets updated/inserted/deleted, I have to update another table in SQL Server 2000. How is it possible to achieve that ?
Thanks in advance
Started by Samiul on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
See SP 4.
I would recommend downloading/install the SQL 2000 SP4.
You should be able to create a SQL Triggers.
Check out: SQL 2000 Triggers .
Linked servers are also supported in MSSQL 2000.
Of MSSQL.
|
Ask your Facebook Friends
|
Is there a way to restore an Sql Server 2005 DB to Sql Server 2000? I'm unable to attach it either. Any tools, ideas etc?
Started by Daud on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
From their blurb: "You can even synchronize....
Because SQL 2005 has more new using sql server 2005 specific features, you'll have to do some manual tweaking.
It worked for me anyway.
It recreates the database.
Server 2000.
|
|
My development under VS2008 Team Suite SP1 with SQL Sever 2005 Express SP3. One of my customer only have SQL Server 2000 License.
I don't start my project yet. So I want to find a way that I can develop on SQL Server 2005 but deploy to SQL Server 2000...
Started by AntiGameZ on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
See this MSDN article to find out what.
Make sure you don't use any new features (T-SQL wise)..
Addition to what blu said...
You can set that to SQL Server 2000 (80).
Menu on the New Database dialog.
|
|
I want to ask is there any issues or risks involved in installation of SQL Server 2005 Enterprise Edition on SQL Server 2000 Enterprise Edition in production server?
Please tell me the guidelines in installation...
Started by ManishKumar1980 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
There are some differences in behavior and the SQL....
Details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75
If you're upgrading a SQL Server 2000 instance to Sql Server 2005 in place, I wouldn't recommend it.
|
|
My development machine has SQL Server 2008 Developer edition on it. A production server I am going to do some development for has SQL Server 2000 on it. Is there a way to create a 2000 database using my 2008 developer edition? Or do I need to create it...
Started by Ronnie Overby on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It depends on how you're going to get the new database back to the production 2000 server; if you create it in your 2008 instance, you can't back it up to SQL 2....
But you can't restore a 2008 db on a 2000 server.
|
|
I have to move an entire database from a SQL Server 2008 machine to a SQL Server 2000 machine.
I created a backup using Management Studio 2008, copied it to the hard drive of the 2000 box, and from withing Management Studio 2008, I choose Restore Database...
Started by spaetzel on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
I've heard you can only do it by generating the SQL, execute it in the 2000....
So no ROW_NUMBER(), no PARTITION, no CTEs, no datetime2 to copy the data from the existing database .
As everything in the db is valid in SQL 2000.
|
|
We have a Sql Server 2000 database application that needs to update our applications Sql Server 2008 database when certain tables are changed. For this, we use a trigger on the Sql 2000 server that fires a stored procedure on our Sql 2008 server. When...
Started by Stuart B on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Firewall settings?
It turns out the same DTC security configuration window on our Sql 2000 server did, but when we upgraded to Server 2008 and Sql Server 2008, this needed to be enabled on BOTH servers....
|
|
In SQL Server 2000, you have the "All Tasks... - Export Data" option. Where is this option the SQL Server 2005 Management Studio?
Or, is there a SQL Server 2005 way of doing this?
EDIT: I am using the Express edition.
EDIT: Joel's response answers my ...
Started by Austin Salonen on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Some use to just do a backup....
The script can be targeted towards SQL 2000 or SQL 2005.
Http://www.microsoft.com/downloads/details.aspx contains data, schema, or both.
The excellent SQL Server Database Publishing Wizard.
|
