sql server codes: databases

Showing posts with label databases. Show all posts

Monday, March 26, 2012

Help on migrating from SQL7 to SQL2K

Hi,
We just installed a new server with SQL2k (OS win2k) on it. We have an old
SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
server. Can someone tell me what is the best way to do so?
Thanks,
SarahSG,
Might want to read:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Hi,
> We just installed a new server with SQL2k (OS win2k) on it. We have an old
> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
> server. Can someone tell me what is the best way to do so?
> Thanks,
> Sarah
>
>|||Hi Jerry,
I found that there is a "Copy database wizard" on sql2k, would that be the
best solution in my case?
Thanks,
Sarah
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
> SG,
> Might want to read:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
> and
> http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
> HTH
> Jerry
> "SG" <sguo@.coopervision.ca> wrote in message
> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> We just installed a new server with SQL2k (OS win2k) on it. We have an
>> old
>> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc. I
>> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
>> server. Can someone tell me what is the best way to do so?
>> Thanks,
>> Sarah
>>
>|||Do you want to replace the existing SQL Server 7 with SQL Server 2000? If
so then the copy database wizard is probably not the best solution. This
wizard is useful at bringing a database over from an existing 7 install to a
new install of 2000 - easier to test database by database this way while
maintaining the originating install.
HTH
Jerry
"SG" <sguo@.coopervision.ca> wrote in message
news:e4GlMs3yFHA.1168@.TK2MSFTNGP15.phx.gbl...
> Hi Jerry,
> I found that there is a "Copy database wizard" on sql2k, would that be the
> best solution in my case?
> Thanks,
> Sarah
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OFsm4K3yFHA.2064@.TK2MSFTNGP09.phx.gbl...
>> SG,
>> Might want to read:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx
>> and
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
>> HTH
>> Jerry
>> "SG" <sguo@.coopervision.ca> wrote in message
>> news:eh7GZE3yFHA.3812@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> We just installed a new server with SQL2k (OS win2k) on it. We have an
>> old
>> SQL7.0 server (OS NT4). It has a few databases, jobs, packages and etc.
>> I
>> like to transfer and convert all the data from SQL 7.0 to the new SQL 2k
>> server. Can someone tell me what is the best way to do so?
>> Thanks,
>> Sarah
>>
>>
>sql

Help on migrating from SQL7 to SQL2K

Wednesday, March 21, 2012

Help on code in a SP

Hi,
I'm currently auditing some SQL servers to have an overview on what's
running/existing in the different databases.
On one of the server, I found User's Stored Procedures in MSDB databases
(which, I think is already not a good idea). My problem is that I can't get
the usage of the SPs.
All are built on the same model : all the code is written on 1 line only.
Here is the full code of one the SP:
-- beginning of the code --
create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.I
conLibrary,@.IconID,@.ShowCollections)
GO
-- end of the code --
If someone would have any clue abotu what's this SP is doing...
Thanks,
ChrisYou are trying to insert into the RTblClassExtension with the values passed.
What is that you would like to know here
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Chris V." <tophe_news@.hotmail.com> wrote in message
news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm currently auditing some SQL servers to have an overview on what's
> running/existing in the different databases.
> On one of the server, I found User's Stored Procedures in MSDB databases
> (which, I think is already not a good idea). My problem is that I can't
get
> the usage of the SPs.
> All are built on the same model : all the code is written on 1 line only.
> Here is the full code of one the SP:
> -- beginning of the code --
> create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
> int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
> bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.I
conLibrary,@.IconID,@.ShowCollections)[vbc
ol=seagreen]
> GO
> -- end of the code --
> If someone would have any clue abotu what's this SP is doing...
> Thanks,
> Chris
>[/vbcol]|||I'm trying to understand what are theses procedures I have into MSDB.
On your opinion, what could be the usage of such insert ?
(I'm not, far from that, expert in SQL. so, any help will be appreciated)
Thx,
Chris
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:cohev5$avs$1@.news01.intel.com...
> You are trying to insert into the RTblClassExtension with the values
passed.
> What is that you would like to know here
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
> "Chris V." <tophe_news@.hotmail.com> wrote in message
> news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
> get
only.
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.I
conLibrary,@.IconID,@.ShowCollections)[vbc
ol=seagreen]
>|||Like you I don't know what its used for either, however I
have in my database which sort of means that its actually
a Microsoft SP, and not a user one.
Sorry I can't be much of a help here, except to lay your
mind at rest.
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill

>--Original Message--
>I'm trying to understand what are theses procedures I
have into MSDB.
>On your opinion, what could be the usage of such insert ?
>(I'm not, far from that, expert in SQL. so, any help will
be appreciated)
>Thx,
>Chris
>"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in
message
>news:cohev5$avs$1@.news01.intel.com...
with the values[vbcol=seagreen]
>passed.
http://www.microsoft.com/sql/techin...tdoc/2000/books
.asp[vbcol=seagreen]
overview on what's[vbcol=seagreen]
Procedures in MSDB databases[vbcol=seagreen]
problem is that I can't[vbcol=seagreen]
written on 1 line[vbcol=seagreen]
>only.
-[vbcol=seagreen]
(8),@.Z_BranchID_Z int,@.Z_VS_Z[vbcol=seagreen]
int=null,@.ShowCollections[vbcol=seagreen
]
RTblClassExtension values[vbcol=seagreen]
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.I
conLibrary,@.IconID,
@.ShowCollections)
is doing...[vbcol=seagreen]
>
>.
>

Help on code in a SP

Hi,
I'm currently auditing some SQL servers to have an overview on what's
running/existing in the different databases.
On one of the server, I found User's Stored Procedures in MSDB databases
(which, I think is already not a good idea). My problem is that I can't get
the usage of the SPs.
All are built on the same model : all the code is written on 1 line only.
Here is the full code of one the SP:
-- beginning of the code --
create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary,@.IconID,@.ShowCollections)
GO
-- end of the code --
If someone would have any clue abotu what's this SP is doing...
Thanks,
ChrisYou are trying to insert into the RTblClassExtension with the values passed.
What is that you would like to know here
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Chris V." <tophe_news@.hotmail.com> wrote in message
news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm currently auditing some SQL servers to have an overview on what's
> running/existing in the different databases.
> On one of the server, I found User's Stored Procedures in MSDB databases
> (which, I think is already not a good idea). My problem is that I can't
get
> the usage of the SPs.
> All are built on the same model : all the code is written on 1 line only.
> Here is the full code of one the SP:
> -- beginning of the code --
> create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
> int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
> bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary,@.IconID,@.ShowCollections)
> GO
> -- end of the code --
> If someone would have any clue abotu what's this SP is doing...
> Thanks,
> Chris
>|||I'm trying to understand what are theses procedures I have into MSDB.
On your opinion, what could be the usage of such insert ?
(I'm not, far from that, expert in SQL. so, any help will be appreciated)
Thx,
Chris
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:cohev5$avs$1@.news01.intel.com...
> You are trying to insert into the RTblClassExtension with the values
passed.
> What is that you would like to know here
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> "Chris V." <tophe_news@.hotmail.com> wrote in message
> news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > I'm currently auditing some SQL servers to have an overview on what's
> > running/existing in the different databases.
> >
> > On one of the server, I found User's Stored Procedures in MSDB databases
> > (which, I think is already not a good idea). My problem is that I can't
> get
> > the usage of the SPs.
> > All are built on the same model : all the code is written on 1 line
only.
> >
> > Here is the full code of one the SP:
> >
> > -- beginning of the code --
> > create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
> > int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
> > bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
> >
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary,@.IconID,@.ShowCollections)
> > GO
> >
> > -- end of the code --
> >
> > If someone would have any clue abotu what's this SP is doing...
> >
> > Thanks,
> > Chris
> >
> >
>|||Like you I don't know what its used for either, however I
have in my database which sort of means that its actually
a Microsoft SP, and not a user one.
Sorry I can't be much of a help here, except to lay your
mind at rest.
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill
>--Original Message--
>I'm trying to understand what are theses procedures I
have into MSDB.
>On your opinion, what could be the usage of such insert ?
>(I'm not, far from that, expert in SQL. so, any help will
be appreciated)
>Thx,
>Chris
>"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in
message
>news:cohev5$avs$1@.news01.intel.com...
>> You are trying to insert into the RTblClassExtension
with the values
>passed.
>> What is that you would like to know here
>> --
>> HTH,
>> Vinod Kumar
>> MCSE, DBA, MCAD, MCSD
>> http://www.extremeexperts.com
>> Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books
.asp
>> "Chris V." <tophe_news@.hotmail.com> wrote in message
>> news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
>> > Hi,
>> >
>> > I'm currently auditing some SQL servers to have an
overview on what's
>> > running/existing in the different databases.
>> >
>> > On one of the server, I found User's Stored
Procedures in MSDB databases
>> > (which, I think is already not a good idea). My
problem is that I can't
>> get
>> > the usage of the SPs.
>> > All are built on the same model : all the code is
written on 1 line
>only.
>> >
>> > Here is the full code of one the SP:
>> >
>> > -- beginning of the code --
-
>> > create procedure <SP_Name> (@.IntID binary
(8),@.Z_BranchID_Z int,@.Z_VS_Z
>> > int,@.IconLibrary varchar(255)=null,@.IconID
int=null,@.ShowCollections
>> > bit=null,@.Z_VE_Z int=2147483647) as insert
RTblClassExtension values
>> >
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary,@.IconID,
@.ShowCollections)
>> > GO
>> >
>> > -- end of the code --
>> >
>> > If someone would have any clue abotu what's this SP
is doing...
>> >
>> > Thanks,
>> > Chris
>> >
>> >
>>
>
>.
>sql

Help on code in a SP

Hi,
I'm currently auditing some SQL servers to have an overview on what's
running/existing in the different databases.
On one of the server, I found User's Stored Procedures in MSDB databases
(which, I think is already not a good idea). My problem is that I can't get
the usage of the SPs.
All are built on the same model : all the code is written on 1 line only.
Here is the full code of one the SP:
-- beginning of the code --
create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary ,@.IconID,@.ShowCollections)
GO
-- end of the code --
If someone would have any clue abotu what's this SP is doing...
Thanks,
Chris
You are trying to insert into the RTblClassExtension with the values passed.
What is that you would like to know here
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Chris V." <tophe_news@.hotmail.com> wrote in message
news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I'm currently auditing some SQL servers to have an overview on what's
> running/existing in the different databases.
> On one of the server, I found User's Stored Procedures in MSDB databases
> (which, I think is already not a good idea). My problem is that I can't
get
> the usage of the SPs.
> All are built on the same model : all the code is written on 1 line only.
> Here is the full code of one the SP:
> -- beginning of the code --
> create procedure <SP_Name> (@.IntID binary(8),@.Z_BranchID_Z int,@.Z_VS_Z
> int,@.IconLibrary varchar(255)=null,@.IconID int=null,@.ShowCollections
> bit=null,@.Z_VE_Z int=2147483647) as insert RTblClassExtension values
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary ,@.IconID,@.ShowCollections)
> GO
> -- end of the code --
> If someone would have any clue abotu what's this SP is doing...
> Thanks,
> Chris
>
|||I'm trying to understand what are theses procedures I have into MSDB.
On your opinion, what could be the usage of such insert ?
(I'm not, far from that, expert in SQL. so, any help will be appreciated)
Thx,
Chris
"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:cohev5$avs$1@.news01.intel.com...
> You are trying to insert into the RTblClassExtension with the values
passed.[vbcol=seagreen]
> What is that you would like to know here
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
> "Chris V." <tophe_news@.hotmail.com> wrote in message
> news:u0Lybtr1EHA.1152@.TK2MSFTNGP14.phx.gbl...
> get
only.
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary ,@.IconID,@.ShowCollections)
>
|||Like you I don't know what its used for either, however I
have in my database which sort of means that its actually
a Microsoft SP, and not a user one.
Sorry I can't be much of a help here, except to lay your
mind at rest.
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill

>--Original Message--
>I'm trying to understand what are theses procedures I
have into MSDB.
>On your opinion, what could be the usage of such insert ?
>(I'm not, far from that, expert in SQL. so, any help will
be appreciated)
>Thx,
>Chris
>"Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in
message[vbcol=seagreen]
>news:cohev5$avs$1@.news01.intel.com...
with the values[vbcol=seagreen]
>passed.
http://www.microsoft.com/sql/techinf...doc/2000/books
..asp[vbcol=seagreen]
overview on what's[vbcol=seagreen]
Procedures in MSDB databases[vbcol=seagreen]
problem is that I can't[vbcol=seagreen]
written on 1 line[vbcol=seagreen]
>only.
-[vbcol=seagreen]
(8),@.Z_BranchID_Z int,@.Z_VS_Z[vbcol=seagreen]
int=null,@.ShowCollections[vbcol=seagreen]
RTblClassExtension values
>
(@.IntID,@.Z_BranchID_Z,@.Z_VS_Z,@.Z_VE_Z,@.IconLibrary ,@.IconID,
@.ShowCollections)[vbcol=seagreen]
is doing...
>
>.
>

Monday, March 19, 2012

Help needed...badly

I am having a problem with SQL server. When I go into enterprise manager and drill down to the Server level, right before you see the databases running on your server, I am getting an error message. The message I am getting is stating:
A connection could not be established to MAINSERVER.
Reason: Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the MAINSERVER node) and try again.
I did this and everything looks right...but I am still getting this message. I would really appreciate some help on this, as we have an update to run on one of the databases. But before I run the update, I must move that database off of the partitian it
is on because the partitian is almost full. Any help would be nice. Thank you in advance.
Tom
This sounds like a drivers issue, I assume yoiu are connecting from a seperate machine than the server. Try re-installing the enterprise management tools.

Help needed...badly

I am having a problem with SQL server. When I go into enterprise manager an
d drill down to the Server level, right before you see the databases running
on your server, I am getting an error message. The message I am getting is
stating:
A connection could not be established to MAINSERVER.
Reason: Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration p
roperties (by right-clicking on the MAINSERVER node) and try again.
I did this and everything looks right...but I am still getting this message.
I would really appreciate some help on this, as we have an update to run o
n one of the databases. But before I run the update, I must move that datab
ase off of the partitian it
is on because the partitian is almost full. Any help would be nice. Thank
you in advance.
TomThis sounds like a drivers issue, I assume yoiu are connecting from a sepera
te machine than the server. Try re-installing the enterprise management tool
s.

Friday, March 9, 2012

Help needed about databases!

I'm a newbie to SQL server.... l'm building a website where companies can save important data. I have a SQL server available but I'm not sure how to store the data. Should I create a new database for every user or should I store everything in the same database and then use a UserId to recognize the data and the user? What about the case where I reaches let's say 1000 users in the one user per database case, it would be extremly difficult to have an overview of the databases or what?

The data stored for each user are stored in tables which are exactly the same so all tables could be gathered into one table and then a UserId could tell which records belong to whom.

Hope my english isn't too bad..otherwise just ask me questions and I'll get back A.S.A.P.

Regards

Joachim

You probably should just use a single database. Unless there are overriding issues like you distribute the database to the company. Then you wouldn't want one company to get another companies data. I'm assuming there is a single application where all the companies log in to the same site. If each company has separate sites, then you might actually need separate apps (and databases) for each.

Single app / db is easier to maintain but realize that changes for one then apply to all.

HTH.

Wednesday, March 7, 2012

HELP- need to convert SQL 6.5 Back Up to 2000

HELP- need to convert SQL 6.5 Back Up to 2000
I have made enterprise manager back ups of two databases
on a SQL 6.5 server. The back ups are .dat files. I
want/need to convert these to SQL 2000 or SQL 7.0. I have
a SQL 2000 server. I tried to create a new database on
the SQL 2000 server and then restore the back ups to the
SQL 2000 server's new database I just created. I get an
error saying that the back up is not valid.
What is the procedure for getting this .dat 6.5 back up to
SQL 2000?
mick2767@.hotmail.comWhat you should do is to use the Upgrade Wizard... If you have the SQL 6.5
server with the dbs installed... Simply go to program files -> SQL Server
and you will find the upgrade wizard... That's the way to go.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<mick2767@.hotmail.com> wrote in message
news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> HELP- need to convert SQL 6.5 Back Up to 2000
> I have made enterprise manager back ups of two databases
> on a SQL 6.5 server. The back ups are .dat files. I
> want/need to convert these to SQL 2000 or SQL 7.0. I have
> a SQL 2000 server. I tried to create a new database on
> the SQL 2000 server and then restore the back ups to the
> SQL 2000 server's new database I just created. I get an
> error saying that the back up is not valid.
> What is the procedure for getting this .dat 6.5 back up to
> SQL 2000?
> mick2767@.hotmail.com|||When you do your restore, make sure that under options...Force restore
over existing database is checked. That might solve your problem.
"Wayne Snyder" <wsnyder@.ikon.com> wrote in message news:<e#z$IxfrDHA.1880@.TK2MSFTNGP09.phx.gbl>...
> What you should do is to use the Upgrade Wizard... If you have the SQL 6.5
> server with the dbs installed... Simply go to program files -> SQL Server
> and you will find the upgrade wizard... That's the way to go.!
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <mick2767@.hotmail.com> wrote in message
> news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> > HELP- need to convert SQL 6.5 Back Up to 2000
> >
> > I have made enterprise manager back ups of two databases
> > on a SQL 6.5 server. The back ups are .dat files. I
> > want/need to convert these to SQL 2000 or SQL 7.0. I have
> > a SQL 2000 server. I tried to create a new database on
> > the SQL 2000 server and then restore the back ups to the
> > SQL 2000 server's new database I just created. I get an
> > error saying that the back up is not valid.
> >
> > What is the procedure for getting this .dat 6.5 back up to
> > SQL 2000?
> >
> > mick2767@.hotmail.com|||As Wayne said in his post: you cannot restore a 6.5 database into 7.0 or 2000.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Indigo Montoya" <Indigo_Montoya_2@.hotmail.com> wrote in message
news:f18452ec.0311181645.5b561bc7@.posting.google.com...
> When you do your restore, make sure that under options...Force restore
> over existing database is checked. That might solve your problem.
>
> "Wayne Snyder" <wsnyder@.ikon.com> wrote in message news:<e#z$IxfrDHA.1880@.TK2MSFTNGP09.phx.gbl>...
> > What you should do is to use the Upgrade Wizard... If you have the SQL 6.5
> > server with the dbs installed... Simply go to program files -> SQL Server
> > and you will find the upgrade wizard... That's the way to go.!
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Computer Education Services Corporation (CESC), Charlotte, NC
> > www.computeredservices.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> > <mick2767@.hotmail.com> wrote in message
> > news:0cc201c3adf9$da109e50$a501280a@.phx.gbl...
> > > HELP- need to convert SQL 6.5 Back Up to 2000
> > >
> > > I have made enterprise manager back ups of two databases
> > > on a SQL 6.5 server. The back ups are .dat files. I
> > > want/need to convert these to SQL 2000 or SQL 7.0. I have
> > > a SQL 2000 server. I tried to create a new database on
> > > the SQL 2000 server and then restore the back ups to the
> > > SQL 2000 server's new database I just created. I get an
> > > error saying that the back up is not valid.
> > >
> > > What is the procedure for getting this .dat 6.5 back up to
> > > SQL 2000?
> > >
> > > mick2767@.hotmail.com

help moving system databases

sql 2000 sp3.
i need to move my system databases to a new drive. i've been reading kb
article 224071. it says to do model before msdb, but it doesn't say
when to do master. so do you do master first or last?
master is independent from the others, as you don't attach or reattach
master, you just change the location in the startup properties in Enterprise
Manager.
Jacco Schalkwijk
SQL Server MVP
"ch" <ch@.dontemailme.com> wrote in message
news:409F91AB.493BB3C4@.dontemailme.com...
> sql 2000 sp3.
> i need to move my system databases to a new drive. i've been reading kb
> article 224071. it says to do model before msdb, but it doesn't say
> when to do master. so do you do master first or last?
>
>

help moving system databases

sql 2000 sp3.
i need to move my system databases to a new drive. i've been reading kb
article 224071. it says to do model before msdb, but it doesn't say
when to do master. so do you do master first or last?master is independent from the others, as you don't attach or reattach
master, you just change the location in the startup properties in Enterprise
Manager.
Jacco Schalkwijk
SQL Server MVP
"ch" <ch@.dontemailme.com> wrote in message
news:409F91AB.493BB3C4@.dontemailme.com...
> sql 2000 sp3.
> i need to move my system databases to a new drive. i've been reading kb
> article 224071. it says to do model before msdb, but it doesn't say
> when to do master. so do you do master first or last?
>
>

help moving system databases

sql 2000 sp3.
i need to move my system databases to a new drive. i've been reading kb
article 224071. it says to do model before msdb, but it doesn't say
when to do master. so do you do master first or last?master is independent from the others, as you don't attach or reattach
master, you just change the location in the startup properties in Enterprise
Manager.
--
Jacco Schalkwijk
SQL Server MVP
"ch" <ch@.dontemailme.com> wrote in message
news:409F91AB.493BB3C4@.dontemailme.com...
> sql 2000 sp3.
> i need to move my system databases to a new drive. i've been reading kb
> article 224071. it says to do model before msdb, but it doesn't say
> when to do master. so do you do master first or last?
>
>

Monday, February 27, 2012

Help me with DB schema comparison method

Hi!
can some one help me guide to knwo as to how do we compare teh database schemas of two databases.. i mean in case i have to compare the schema of 2 ole dbs or 2 sql databases then i can do it using teh XML schema \ and compare but then in case i need to compare a SQL schema and a oledb schema then how do i go about it.. since the long datatype in ms access ( using ole db) is text in SQL and tiny int is int16... there are some other discripancies liek that. So how do i go about checking teh database schemas for such disperate DBs. Can soem one tell me some site or give soem guidance in this regard. Please help me as i need it for my project where i need to compare teh schema and alert when they are not compatible.. Please help...thanks in advance..

regards,
GautamDo you have microsoft visio available to you? It can reverse engineer your database to output a great map for you to review.|||hey crispy!!!
That did not help me in anyway...please suggest somethign good... by the way .. i am sorry i did not use visio tool before.

Thanks anyway
Gautam

Monday, March 26, 2012

Help on migrating from SQL7 to SQL2K

Help on migrating from SQL7 to SQL2K

Help on migrating from SQL7 to SQL2K

Wednesday, March 21, 2012

Help on code in a SP

Help on code in a SP

Help on code in a SP

Monday, March 19, 2012

Help needed...badly

Help needed...badly

Friday, March 9, 2012

Help needed about databases!

Wednesday, March 7, 2012

HELP- need to convert SQL 6.5 Back Up to 2000

help moving system databases

help moving system databases

help moving system databases

Monday, February 27, 2012

Help me with DB schema comparison method

sql server codes

Blog Archive

About Me