moving a db from 2005 to 2000

I have a vendor who uses sql server 2005 but we are currently using 2000 sp4
.
He has sent me a mdf, a ldf file and a bak file. I would like to get this
on my ss2k server. What is the best way to do this?
I've tried restoring the bak file but it tells me that there is a
compatibility problem.
I've tried to create a new db, detach and reattach the mdf and ldf file that
the vendor sent and I get the following error:
Error 602: Could not find row in sysindexes for database ID XX, object ID
X, index ID X. Run DBCC Checktable on sysindexes.
Does this mean that I need to run DBCC checktable on sysindexes on the
master db?
I ran this on my ss2k machine. Should the vendor run the dbcc
checktable(sysindexes) on his 2005 machine first and then ship me the mdf an
d
ldf?
Got to get this somehow, all suggestions are greatly appreciated.
EdieCould you have the vendor restore the database as a different name on their
2005 server (so as not to disrupt their real copy), change the compatibility
to 80, then back *that* up, and try restoring that on 2000? I haven't tried
that, it's just an outside suggestion.
You could follow the same steps and try it yourself, if you have a 2005
instance available (or could set one up).
"Edie Richardson" <EdieRichardson@.discussions.microsoft.com> wrote in
message news:E9B97EAB-4F28-4F88-BBAD-D268B4538AE5@.microsoft.com...
>I have a vendor who uses sql server 2005 but we are currently using 2000
>sp4.
> He has sent me a mdf, a ldf file and a bak file. I would like to get
> this
> on my ss2k server. What is the best way to do this?
> I've tried restoring the bak file but it tells me that there is a
> compatibility problem.
> I've tried to create a new db, detach and reattach the mdf and ldf file
> that
> the vendor sent and I get the following error:
> Error 602: Could not find row in sysindexes for database ID XX, object ID
> X, index ID X. Run DBCC Checktable on sysindexes.
> Does this mean that I need to run DBCC checktable on sysindexes on the
> master db?
> I ran this on my ss2k machine. Should the vendor run the dbcc
> checktable(sysindexes) on his 2005 machine first and then ship me the mdf
> and
> ldf?
> Got to get this somehow, all suggestions are greatly appreciated.
> Edie|||You cannot get a 2005 database into 2000 at the binary level (using either r
estore or attach).
Script and BCP/DTS/BULK INSERT etc is the way to go here. Compatibility leve
l of the database does
not change this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Edie Richardson" <EdieRichardson@.discussions.microsoft.com> wrote in messag
e
news:E9B97EAB-4F28-4F88-BBAD-D268B4538AE5@.microsoft.com...
>I have a vendor who uses sql server 2005 but we are currently using 2000 sp
4.
> He has sent me a mdf, a ldf file and a bak file. I would like to get thi
s
> on my ss2k server. What is the best way to do this?
> I've tried restoring the bak file but it tells me that there is a
> compatibility problem.
> I've tried to create a new db, detach and reattach the mdf and ldf file th
at
> the vendor sent and I get the following error:
> Error 602: Could not find row in sysindexes for database ID XX, object ID
> X, index ID X. Run DBCC Checktable on sysindexes.
> Does this mean that I need to run DBCC checktable on sysindexes on the
> master db?
> I ran this on my ss2k machine. Should the vendor run the dbcc
> checktable(sysindexes) on his 2005 machine first and then ship me the mdf
and
> ldf?
> Got to get this somehow, all suggestions are greatly appreciated.
> Edie|||> Script and BCP/DTS/BULK INSERT etc is the way to go here. Compatibility
> level of the database does not change this.
Ugh, hadn't tried it...

moving a database causes it to be read-only

Using SS2000 SP4. I've done this many times before without problem so I don'
t
know why I'm having trouble this time. I'm running out of space on a drive s
o
I'm moving some databases to another drive. I've tried this with EM and QA
using this query:
EXEC sp_detach_db 'jg', 'false'
EXEC sp_attach_db @.dbname = 'jg',
@.filename1 = 'S:\SQL\Data\jg_Data.mdf',
@.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
After attaching the database, the database comes up read-only. Can someone
tell me why?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. I've done this many times before without problem so I do
n't
> know why I'm having trouble this time. I'm running out of space on a drive
so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
Do you get an error when you try to make them not read-only?
Have you checked the readonly attribute on these files? To uncheck them you
will need to detach the database again.
How did you move the files?
John|||I didn't get an error. I did this twice on two different databases and had
the same problem both times. I didn't check the readonly attribute but since
I moved the files using drag-and-drop, I wouldn't expect the attribute to
change.
I had a backup of the database and I restored it and didn't have any problem
.
Thanks,
--
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> Do you get an error when you try to make them not read-only?
> Have you checked the readonly attribute on these files? To uncheck them yo
u
> will need to detach the database again.
> How did you move the files?
> John|||Hi Dan
"Dan D." wrote:

> I didn't get an error. I did this twice on two different databases and had
> the same problem both times. I didn't check the readonly attribute but sin
ce
> I moved the files using drag-and-drop, I wouldn't expect the attribute to
> change.
> I had a backup of the database and I restored it and didn't have any probl
em.
> Thanks,
> --
> Dan D.
If you didn't get an error changing the database from readonly the file
attributes must be ok. I did find this
http://forums.microsoft.com/MSDN/Sh...303056&SiteID=1 where
the service accounts permissions on the directory has an impact, so it may b
e
your permissions rather than the service accounts if you backup/restore work
s
ok.
John
John|||Hi,
I know that in SQL 2005 when attaching databases they come up in a state of
reduced functinality. This is a security measure to make sure that someone
cannot attach a database that gives them more permsissions than they might
otherwise have. Maybe some of this concept made it into SQL2000 SP4.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:5F9EE66C-31AC-4AC6-A971-7613346DBE1D@.microsoft.com...
> Using SS2000 SP4. I've done this many times before without problem so I
> don't
> know why I'm having trouble this time. I'm running out of space on a drive
> so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.|||It was the security on the folder that I was moving the data to. The user
didn't have enough permissions.
Thanks,
--
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> If you didn't get an error changing the database from readonly the file
> attributes must be ok. I did find this
> http://forums.microsoft.com/MSDN/Sh...303056&SiteID=1 wher
e
> the service accounts permissions on the directory has an impact, so it may
be
> your permissions rather than the service accounts if you backup/restore wo
rks
> ok.
> John
> John

moving a database causes it to be read-only

Using SS2000 SP4. I've done this many times before without problem so I don't
know why I'm having trouble this time. I'm running out of space on a drive so
I'm moving some databases to another drive. I've tried this with EM and QA
using this query:
EXEC sp_detach_db 'jg', 'false'
EXEC sp_attach_db @.dbname = 'jg',
@.filename1 = 'S:\SQL\Data\jg_Data.mdf',
@.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
After attaching the database, the database comes up read-only. Can someone
tell me why?
Thanks,
--
Dan D.Hi Dan
"Dan D." wrote:
> Using SS2000 SP4. I've done this many times before without problem so I don't
> know why I'm having trouble this time. I'm running out of space on a drive so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
Do you get an error when you try to make them not read-only?
Have you checked the readonly attribute on these files? To uncheck them you
will need to detach the database again.
How did you move the files?
John|||I didn't get an error. I did this twice on two different databases and had
the same problem both times. I didn't check the readonly attribute but since
I moved the files using drag-and-drop, I wouldn't expect the attribute to
change.
I had a backup of the database and I restored it and didn't have any problem.
Thanks,
--
Dan D.
"John Bell" wrote:
> Hi Dan
> "Dan D." wrote:
> > Using SS2000 SP4. I've done this many times before without problem so I don't
> > know why I'm having trouble this time. I'm running out of space on a drive so
> > I'm moving some databases to another drive. I've tried this with EM and QA
> > using this query:
> > EXEC sp_detach_db 'jg', 'false'
> > EXEC sp_attach_db @.dbname = 'jg',
> > @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> > @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> >
> > After attaching the database, the database comes up read-only. Can someone
> > tell me why?
> >
> > Thanks,
> > --
> > Dan D.
> Do you get an error when you try to make them not read-only?
> Have you checked the readonly attribute on these files? To uncheck them you
> will need to detach the database again.
> How did you move the files?
> John|||Hi Dan
"Dan D." wrote:
> I didn't get an error. I did this twice on two different databases and had
> the same problem both times. I didn't check the readonly attribute but since
> I moved the files using drag-and-drop, I wouldn't expect the attribute to
> change.
> I had a backup of the database and I restored it and didn't have any problem.
> Thanks,
> --
> Dan D.
If you didn't get an error changing the database from readonly the file
attributes must be ok. I did find this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
the service accounts permissions on the directory has an impact, so it may be
your permissions rather than the service accounts if you backup/restore works
ok.
John
John|||Hi,
I know that in SQL 2005 when attaching databases they come up in a state of
reduced functinality. This is a security measure to make sure that someone
cannot attach a database that gives them more permsissions than they might
otherwise have. Maybe some of this concept made it into SQL2000 SP4.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:5F9EE66C-31AC-4AC6-A971-7613346DBE1D@.microsoft.com...
> Using SS2000 SP4. I've done this many times before without problem so I
> don't
> know why I'm having trouble this time. I'm running out of space on a drive
> so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.|||It was the security on the folder that I was moving the data to. The user
didn't have enough permissions.
Thanks,
--
Dan D.
"John Bell" wrote:
> Hi Dan
> "Dan D." wrote:
> > I didn't get an error. I did this twice on two different databases and had
> > the same problem both times. I didn't check the readonly attribute but since
> > I moved the files using drag-and-drop, I wouldn't expect the attribute to
> > change.
> >
> > I had a backup of the database and I restored it and didn't have any problem.
> >
> > Thanks,
> > --
> > Dan D.
> If you didn't get an error changing the database from readonly the file
> attributes must be ok. I did find this
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
> the service accounts permissions on the directory has an impact, so it may be
> your permissions rather than the service accounts if you backup/restore works
> ok.
> John
> John

moving a database causes it to be read-only

Using SS2000 SP4. I've done this many times before without problem so I don't
know why I'm having trouble this time. I'm running out of space on a drive so
I'm moving some databases to another drive. I've tried this with EM and QA
using this query:
EXEC sp_detach_db 'jg', 'false'
EXEC sp_attach_db @.dbname = 'jg',
@.filename1 = 'S:\SQL\Data\jg_Data.mdf',
@.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
After attaching the database, the database comes up read-only. Can someone
tell me why?
Thanks,
Dan D.
Hi Dan
"Dan D." wrote:

> Using SS2000 SP4. I've done this many times before without problem so I don't
> know why I'm having trouble this time. I'm running out of space on a drive so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
Do you get an error when you try to make them not read-only?
Have you checked the readonly attribute on these files? To uncheck them you
will need to detach the database again.
How did you move the files?
John
|||I didn't get an error. I did this twice on two different databases and had
the same problem both times. I didn't check the readonly attribute but since
I moved the files using drag-and-drop, I wouldn't expect the attribute to
change.
I had a backup of the database and I restored it and didn't have any problem.
Thanks,
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> Do you get an error when you try to make them not read-only?
> Have you checked the readonly attribute on these files? To uncheck them you
> will need to detach the database again.
> How did you move the files?
> John
|||Hi Dan
"Dan D." wrote:

> I didn't get an error. I did this twice on two different databases and had
> the same problem both times. I didn't check the readonly attribute but since
> I moved the files using drag-and-drop, I wouldn't expect the attribute to
> change.
> I had a backup of the database and I restored it and didn't have any problem.
> Thanks,
> --
> Dan D.
If you didn't get an error changing the database from readonly the file
attributes must be ok. I did find this
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
the service accounts permissions on the directory has an impact, so it may be
your permissions rather than the service accounts if you backup/restore works
ok.
John
John
|||Hi,
I know that in SQL 2005 when attaching databases they come up in a state of
reduced functinality. This is a security measure to make sure that someone
cannot attach a database that gives them more permsissions than they might
otherwise have. Maybe some of this concept made it into SQL2000 SP4.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:5F9EE66C-31AC-4AC6-A971-7613346DBE1D@.microsoft.com...
> Using SS2000 SP4. I've done this many times before without problem so I
> don't
> know why I'm having trouble this time. I'm running out of space on a drive
> so
> I'm moving some databases to another drive. I've tried this with EM and QA
> using this query:
> EXEC sp_detach_db 'jg', 'false'
> EXEC sp_attach_db @.dbname = 'jg',
> @.filename1 = 'S:\SQL\Data\jg_Data.mdf',
> @.filename2 = 'E:\SQL\LOGS\jg_log.ldf'
> After attaching the database, the database comes up read-only. Can someone
> tell me why?
> Thanks,
> --
> Dan D.
|||It was the security on the folder that I was moving the data to. The user
didn't have enough permissions.
Thanks,
Dan D.
"John Bell" wrote:

> Hi Dan
> "Dan D." wrote:
>
> If you didn't get an error changing the database from readonly the file
> attributes must be ok. I did find this
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=303056&SiteID=1 where
> the service accounts permissions on the directory has an impact, so it may be
> your permissions rather than the service accounts if you backup/restore works
> ok.
> John
> John
sql

moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file or store the output of select command
from sql server 2000 in a format which is easy to upload in sql server 20005
in right format (columns). The file is big and can not stored in excel format.
Thanks
jpr
I have set query options. It works.
ontario, canada
"db" wrote:

> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQL
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file or store the output of select command
> from sql server 2000 in a format which is easy to upload in sql server 20005
> in right format (columns). The file is big and can not stored in excel format.
> Thanks
> jpr
>

Moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file. The file is big and can not stoted in
excel format.
Thanks
jpr
I have set query options. It works.
"db" wrote:

> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQL
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file. The file is big and can not stoted in
> excel format.
> Thanks
> jpr
>

moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file or store the output of select command
from sql server 2000 in a format which is easy to upload in sql server 20005
in right format (columns). The file is big and can not stored in excel forma
t.
Thanks
jprI have set query options. It works.
--
ontario, canada
"db" wrote:

> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQ
L
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file or store the output of select command
> from sql server 2000 in a format which is easy to upload in sql server 200
05
> in right format (columns). The file is big and can not stored in excel for
mat.
> Thanks
> jpr
>

Moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file. The file is big and can not stoted in
excel format.
Thanks
jprI have set query options. It works.
--
"db" wrote:

> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQ
L
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file. The file is big and can not stoted in
> excel format.
> Thanks
> jpr
>sql

Moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file. The file is big and can not stoted in
excel format.
Thanks
jprI have set query options. It works.
--
"db" wrote:
> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQL
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file. The file is big and can not stoted in
> excel format.
> Thanks
> jpr
>

moveing data

Hi
I need to move data from few tables in sql server 2000 SP4 to sql server
2005 database. I can select the data using a select command from all the
tables and save it in a text file.
Now When I try to import it into destination server from txt file using SQL
server import export wizard, It is importing it in one column only. How to
define column delimiter in the file or store the output of select command
from sql server 2000 in a format which is easy to upload in sql server 20005
in right format (columns). The file is big and can not stored in excel format.
Thanks
jprI have set query options. It works.
--
ontario, canada
"db" wrote:
> Hi
> I need to move data from few tables in sql server 2000 SP4 to sql server
> 2005 database. I can select the data using a select command from all the
> tables and save it in a text file.
> Now When I try to import it into destination server from txt file using SQL
> server import export wizard, It is importing it in one column only. How to
> define column delimiter in the file or store the output of select command
> from sql server 2000 in a format which is easy to upload in sql server 20005
> in right format (columns). The file is big and can not stored in excel format.
> Thanks
> jpr
>

move settings from Database1 to Database2

Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
have two DataBases.
Database1
-Tables <- (with data and settings like Key and Constraints)
-Views
-Stored Procedure
Database2
-Tables < with Data
my question is:
how can i move Views\Stored Procedure and the Table Settings like KEY
and Constraints to the Database2 and keep the Data in the Tables of
Database2
best regards Jarosaw Kucharski
On Feb 19, 12:18 pm, jaroslaw.kuchar...@.3dac.net wrote:
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
for views and proc you can generate a script. No Idea on keys and
constraints.
~Shiju
|||Hi
You can generate ascript of those objects (for SP and Views) and just run it
on destination database
In case of tables , (script out all keys and contraints ) use alter
table... command to create contsraints (for more details please read BOL)
<jaroslaw.kucharski@.3dac.net> wrote in message
news:1171869504.143391.31440@.t69g2000cwt.googlegro ups.com...
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>
|||Hi
"jaroslaw.kucharski@.3dac.net" wrote:

> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>
If you want an exact copy of Database1 named Database2 you can
backup/restore the database giving the destination database a different name
and renaming the data and log files if necessary see
http://support.microsoft.com/kb/314546
If you only want to transfer a subset of objects then you could use the
Import/Export wizard (i.e. DTS). DTS could also be used for periodic
refreshes of the data.
HTH
John

move settings from Database1 to Database2

Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
have two DataBases.
Database1
-Tables <- (with data and settings like Key and Constraints)
-Views
-Stored Procedure
Database2
-Tables < with Data
my question is:
how can i move Views\Stored Procedure and the Table Settings like KEY
and Constraints to the Database2 and keep the Data in the Tables of
Database2
best regards Jarosaw KucharskiOn Feb 19, 12:18 pm, jaroslaw.kuchar...@.3dac.net wrote:
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
for views and proc you can generate a script. No Idea on keys and
constraints.
~Shiju|||Hi
You can generate ascript of those objects (for SP and Views) and just run it
on destination database
In case of tables , (script out all keys and contraints ) use alter
table... command to create contsraints (for more details please read BOL)
<jaroslaw.kucharski@.3dac.net> wrote in message
news:1171869504.143391.31440@.t69g2000cwt.googlegroups.com...
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>|||Hi
"jaroslaw.kucharski@.3dac.net" wrote:
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>
If you want an exact copy of Database1 named Database2 you can
backup/restore the database giving the destination database a different name
and renaming the data and log files if necessary see
http://support.microsoft.com/kb/314546
If you only want to transfer a subset of objects then you could use the
Import/Export wizard (i.e. DTS). DTS could also be used for periodic
refreshes of the data.
HTH
John

move settings from Database1 to Database2

Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
have two DataBases.
Database1
-Tables <- (with data and settings like Key and Constraints)
-Views
-Stored Procedure
Database2
-Tables < with Data
my question is:
how can i move Views\Stored Procedure and the Table Settings like KEY
and Constraints to the Database2 and keep the Data in the Tables of
Database2
best regards Jarosaw KucharskiOn Feb 19, 12:18 pm, jaroslaw.kuchar...@.3dac.net wrote:
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
for views and proc you can generate a script. No Idea on keys and
constraints.
~Shiju|||Hi
You can generate ascript of those objects (for SP and Views) and just run it
on destination database
In case of tables , (script out all keys and contraints ) use alter
table... command to create contsraints (for more details please read BOL)
<jaroslaw.kucharski@.3dac.net> wrote in message
news:1171869504.143391.31440@.t69g2000cwt.googlegroups.com...
> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>|||Hi
"jaroslaw.kucharski@.3dac.net" wrote:

> Hello, i have a SQL Server 2000 from Microsoft SP4. On the Server i
> have two DataBases.
> Database1
> -Tables <- (with data and settings like Key and Constraints)
> -Views
> -Stored Procedure
> Database2
> -Tables < with Data
>
> my question is:
> how can i move Views\Stored Procedure and the Table Settings like KEY
> and Constraints to the Database2 and keep the Data in the Tables of
> Database2
> best regards Jarosaw Kucharski
>
If you want an exact copy of Database1 named Database2 you can
backup/restore the database giving the destination database a different name
and renaming the data and log files if necessary see
http://support.microsoft.com/kb/314546
If you only want to transfer a subset of objects then you could use the
Import/Export wizard (i.e. DTS). DTS could also be used for periodic
refreshes of the data.
HTH
John

MS Reporting Services Error

I have MS RS installed on the W2K3 EE member server, SQL 2000 SP4 and IIS 6
are also installed on the same machine.
For some reason when I connect to:
http://<servername>/reports
or
http://<IP>/reports
or
http://<Localhost>/reports
I'm showed the error message:
"The underlying connection was closed: Unable to connect to the remote
server."
From checking the web and this newsgroup it is clear that there is very
little information about this which leads me to believe this must be some
obvious setting that most people are aware of. Can anyone provide assistance?
Thanks in Advance,
CRHave you checked the event logs on the server?
One other things that come to mind is connection timeouts.
Check the newsgroup on how to change this.
I did have an issue installing RS on a domain controller basically it
didn't set up the ASPNet user properly but I was generally getting
permission denied problems with this one.
Chris
CR wrote:
> I have MS RS installed on the W2K3 EE member server, SQL 2000 SP4 and
> IIS 6 are also installed on the same machine.
> For some reason when I connect to:
> http://<servername>/reports
> or
> http://<IP>/reports
> or
> http://<Localhost>/reports
> I'm showed the error message:
> "The underlying connection was closed: Unable to connect to the
> remote server."
> From checking the web and this newsgroup it is clear that there is
> very little information about this which leads me to believe this
> must be some obvious setting that most people are aware of. Can
> anyone provide assistance?
> Thanks in Advance,
> CR