moving a project to another machine

Hey,
I have copied a C# express edition project from another machine and have opened the project up and changed the connection string but the project is not updating the database when I try to insert values from textboxes in forms. They seem do be getting into the dataset but not the sql datatabase.
I am getting alot of messages saying that it could not find the schema information for the dataset. Could these errors have anything to do with the project?
What else do I have to change in the project?

Thanks in advance.

Hi, Yorick85

What kind of database were you using?

In general, please check the database permission to your local machine. And make sure that connection has been correct.

Thanks

|||Hi,

I am using SQL server 2005 on both machines. How do I check the database permission on my local machine?
Thanks
|||

It depends on what is your connection string security mode, windows Authentication or sql server Authentication?

If it need user name or password in the Authentication, you should check the user and role in Sql Server Management Studio for particular database.

Thanks

sql

moving a project to another machine

Hey,
I have copied a C# express edition project from another machine and have opened the project up and changed the connection string but the project is not updating the database when I try to insert values from textboxes in forms. They seem do be getting into the dataset but not the sql datatabase.
I am getting alot of messages saying that it could not find the schema information for the dataset. Could these errors have anything to do with the project?
What else do I have to change in the project?

Thanks in advance.

Hi, Yorick85

What kind of database were you using?

In general, please check the database permission to your local machine. And make sure that connection has been correct.

Thanks

|||Hi,

I am using SQL server 2005 on both machines. How do I check the database permission on my local machine?
Thanks
|||

It depends on what is your connection string security mode, windows Authentication or sql server Authentication?

If it need user name or password in the Authentication, you should check the user and role in Sql Server Management Studio for particular database.

Thanks

Moving a DB from 1 Server 2 another

Hi all,
I have a databse on an SQL Server 2000 that I need to move to another
one.
If I can get a network connection between both servers, I can do this
easily
within Enterprise Manager, but what if I need to physically take the DB
to that server? Assuming that I can't get a network connection, how
would
I get the DB into the other server?
I backuped the DB and tried to restore it on a second test server that I
have,
but I could not get the Restore process to locate the backup file.
Thanks for your time and assistance.
SagaSaga,
Did the account have access to the directory containing the backup file?
Try Restore Database --> From Device --> Select Devices...--> Add... -->
Then click the elipses button and choose the backup filename.
Also, check out:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546/en-us
HTH
Jerry
"Saga" <antiSpam@.somewhere.com> wrote in message
news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have a databse on an SQL Server 2000 that I need to move to another one.
> If I can get a network connection between both servers, I can do this
> easily
> within Enterprise Manager, but what if I need to physically take the DB
> to that server? Assuming that I can't get a network connection, how would
> I get the DB into the other server?
> I backuped the DB and tried to restore it on a second test server that I
> have,
> but I could not get the Restore process to locate the backup file.
> Thanks for your time and assistance.
> Saga
>|||Thanks Jerry!
I will have a look at the info that you mention. I got lucky... I was able to
register both SQL Servers in my Enterprise Manager, so the DB transfer
went along perfectly, but I am going to look into the info that you mention
because whenever I will need this I know I will need it bad :-)
Regards
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? Try Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses button and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> I have a databse on an SQL Server 2000 that I need to move to another one.
>> If I can get a network connection between both servers, I can do this easily
>> within Enterprise Manager, but what if I need to physically take the DB
>> to that server? Assuming that I can't get a network connection, how would
>> I get the DB into the other server?
>> I backuped the DB and tried to restore it on a second test server that I have,
>> but I could not get the Restore process to locate the backup file.
>> Thanks for your time and assistance.
>> Saga
>>
>|||PS: I tried the procedure that you outline in your message and the DB restored
beautifully!
Thanks again
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? Try Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses button and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> I have a databse on an SQL Server 2000 that I need to move to another one.
>> If I can get a network connection between both servers, I can do this easily
>> within Enterprise Manager, but what if I need to physically take the DB
>> to that server? Assuming that I can't get a network connection, how would
>> I get the DB into the other server?
>> I backuped the DB and tried to restore it on a second test server that I have,
>> but I could not get the Restore process to locate the backup file.
>> Thanks for your time and assistance.
>> Saga
>>
>

Moving a DB from 1 Server 2 another

Hi all,
I have a databse on an SQL Server 2000 that I need to move to another
one.
If I can get a network connection between both servers, I can do this
easily
within Enterprise Manager, but what if I need to physically take the DB
to that server? Assuming that I can't get a network connection, how
would
I get the DB into the other server?
I backuped the DB and tried to restore it on a second test server that I
have,
but I could not get the Restore process to locate the backup file.
Thanks for your time and assistance.
SagaSaga,
Did the account have access to the directory containing the backup file?
Try Restore Database --> From Device --> Select Devices...--> Add... -->
Then click the elipses button and choose the backup filename.
Also, check out:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/kb/314546/en-us
HTH
Jerry
"Saga" <antiSpam@.somewhere.com> wrote in message
news:eXJ4NXeeGHA.1812@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have a databse on an SQL Server 2000 that I need to move to another one.
> If I can get a network connection between both servers, I can do this
> easily
> within Enterprise Manager, but what if I need to physically take the DB
> to that server? Assuming that I can't get a network connection, how would
> I get the DB into the other server?
> I backuped the DB and tried to restore it on a second test server that I
> have,
> but I could not get the Restore process to locate the backup file.
> Thanks for your time and assistance.
> Saga
>|||Thanks Jerry!
I will have a look at the info that you mention. I got lucky... I was able t
o
register both SQL Servers in my Enterprise Manager, so the DB transfer
went along perfectly, but I am going to look into the info that you mention
because whenever I will need this I know I will need it bad :-)
Regards
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? T
ry Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses b
utton and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2
MSFTNGP04.phx.gbl...
>|||PS: I tried the procedure that you outline in your message and the DB restor
ed
beautifully!
Thanks again
Saga
"Jerry Spivey" <jspiveyNON@.SPAMMEvestas-awt.com> wrote in message
news:OnNNQgfeGHA.4656@.TK2MSFTNGP05.phx.gbl...
> Saga,
> Did the account have access to the directory containing the backup file? T
ry Restore Database -->
> From Device --> Select Devices...--> Add... --> Then click the elipses b
utton and choose the
> backup filename.
> Also, check out:
> How to move databases between computers that are running SQL Server
> http://support.microsoft.com/kb/314546/en-us
>
> HTH
> Jerry
> "Saga" <antiSpam@.somewhere.com> wrote in message news:eXJ4NXeeGHA.1812@.TK2
MSFTNGP04.phx.gbl...
>

Move the contents of a table from local server to remote server(main server)

hi, I am having a problem in exporting or importind data into a table from
one server to another .Actually some time the connection breaks or the
server gives error message as primary pane full.and the process is
termineted.Can u please suggest me some method to transfer the table and its
content from one table to another in lesser time and with more accuracy.
Thanks and regard,
Irshad Ahmad.Hello Irshad,
Which method are you using to Tranfer the Data ?
Is it between SQL Servers ?
Could you post the exact error message reported by the tool ?
Thanks & Regards
Vishal|||yah i am transferring the data between sqlservers and the error generated is
"Primary File group Full" after something around 30 -40 thousand rows have
been transferred.
"Vishal Gandhi" <vishalg@.microsoft.com> wrote in message
news:KSsMFAxgGHA.4896@.TK2MSFTNGXA01.phx.gbl...
> Hello Irshad,
> Which method are you using to Tranfer the Data ?
> Is it between SQL Servers ?
> Could you post the exact error message reported by the tool ?
> Thanks & Regards
> Vishal
>|||Increase the size of the database file which is full (probably the mdf file).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Irshad Ahmad" <efextra@.newsgroups.nospam> wrote in message
news:efNZGR9gGHA.896@.TK2MSFTNGP02.phx.gbl...
> yah i am transferring the data between sqlservers and the error generated is "Primary File group
> Full" after something around 30 -40 thousand rows have been transferred.
> "Vishal Gandhi" <vishalg@.microsoft.com> wrote in message
> news:KSsMFAxgGHA.4896@.TK2MSFTNGXA01.phx.gbl...
>> Hello Irshad,
>> Which method are you using to Tranfer the Data ?
>> Is it between SQL Servers ?
>> Could you post the exact error message reported by the tool ?
>> Thanks & Regards
>> Vishal
>

Move the contents of a table from local server to remote server(main server)

hi, I am having a problem in exporting or importind data into a table from
one server to another .Actually some time the connection breaks or the
server gives error message as primary pane full.and the process is
termineted.Can u please suggest me some method to transfer the table and its
content from one table to another in lesser time and with more accuracy.
Thanks and regard,
Irshad Ahmad.Hello Irshad,
Which method are you using to Tranfer the Data ?
Is it between SQL Servers ?
Could you post the exact error message reported by the tool ?
Thanks & Regards
Vishal|||yah i am transferring the data between sqlservers and the error generated is
"Primary File group Full" after something around 30 -40 thousand rows have
been transferred.
"Vishal Gandhi" <vishalg@.microsoft.com> wrote in message
news:KSsMFAxgGHA.4896@.TK2MSFTNGXA01.phx.gbl...
> Hello Irshad,
> Which method are you using to Tranfer the Data ?
> Is it between SQL Servers ?
> Could you post the exact error message reported by the tool ?
> Thanks & Regards
> Vishal
>|||Increase the size of the database file which is full (probably the mdf file)
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Irshad Ahmad" <efextra@.newsgroups.nospam> wrote in message
news:efNZGR9gGHA.896@.TK2MSFTNGP02.phx.gbl...
> yah i am transferring the data between sqlservers and the error generated
is "Primary File group
> Full" after something around 30 -40 thousand rows have been transferred.
> "Vishal Gandhi" <vishalg@.microsoft.com> wrote in message
> news:KSsMFAxgGHA.4896@.TK2MSFTNGXA01.phx.gbl...
>

Moving instance of Sql server to different location

Is it possible to move an instance sql server from one drive to another, i.e
.
C: to D: without changing connection properties referenced in DTS packages,
etc.?
T.I.A.This should help:
http://support.microsoft.com/kb/224071
-oj
"LNN" <LNN@.discussions.microsoft.com> wrote in message
news:BE7ADDBD-6113-4BB2-9695-DEB61FC00A91@.microsoft.com...
> Is it possible to move an instance sql server from one drive to another,
> i.e.
> C: to D: without changing connection properties referenced in DTS
> packages,
> etc.?
> T.I.A.|||Hi
If you are moving a database then the connection properties will not change
if you following the instructions in the link posted by oj. If you are
rebuilding a new server and want to rename that server (to be the original
server's name) then you will also need
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
John
"LNN" wrote:

> Is it possible to move an instance sql server from one drive to another, i
.e.
> C: to D: without changing connection properties referenced in DTS packages
,
> etc.?
> T.I.A.