Moving an encrypted SQL Server DB to another server.

How can I move and encrypted database to another SQL Server 2005 box?
Can I just do an export of the database?
I read that I need to do this:
When an encrypted database is copied, restored, or attached to a new
instance of SQL Server, a copy of the database master key encrypted by the
service master key is not stored in master on the destination server
instance. On the destination server instance, you must open the master key of
the database. To open the master key, execute the following statement: OPEN
MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
enable automatic decryption of the database master key by executing the
following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
This ALTER MASTER KEY statement provisions the server instance with a copy of
the database master key that is encrypted with the service master key.
Is the above correct?
Thanks,
Warren
In what way did you encrypt the database?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Warren" <Warren@.discussions.microsoft.com> wrote in message
news:8857450C-395F-4CCA-9E8E-45D11ADC8C2D@.microsoft.com...
> How can I move and encrypted database to another SQL Server 2005 box?
> Can I just do an export of the database?
> I read that I need to do this:
> When an encrypted database is copied, restored, or attached to a new
> instance of SQL Server, a copy of the database master key encrypted by the
> service master key is not stored in master on the destination server
> instance. On the destination server instance, you must open the master key of
> the database. To open the master key, execute the following statement: OPEN
> MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
> enable automatic decryption of the database master key by executing the
> following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
> This ALTER MASTER KEY statement provisions the server instance with a copy of
> the database master key that is encrypted with the service master key.
> Is the above correct?
> Thanks,
> Warren
>
sql

Moving an encrypted SQL Server DB to another server.

How can I move and encrypted database to another SQL Server 2005 box?
Can I just do an export of the database?
I read that I need to do this:
When an encrypted database is copied, restored, or attached to a new
instance of SQL Server, a copy of the database master key encrypted by the
service master key is not stored in master on the destination server
instance. On the destination server instance, you must open the master key o
f
the database. To open the master key, execute the following statement: OPEN
MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
enable automatic decryption of the database master key by executing the
following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
This ALTER MASTER KEY statement provisions the server instance with a copy o
f
the database master key that is encrypted with the service master key.
Is the above correct?
Thanks,
WarrenIn what way did you encrypt the database?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Warren" <Warren@.discussions.microsoft.com> wrote in message
news:8857450C-395F-4CCA-9E8E-45D11ADC8C2D@.microsoft.com...
> How can I move and encrypted database to another SQL Server 2005 box?
> Can I just do an export of the database?
> I read that I need to do this:
> When an encrypted database is copied, restored, or attached to a new
> instance of SQL Server, a copy of the database master key encrypted by the
> service master key is not stored in master on the destination server
> instance. On the destination server instance, you must open the master key
of
> the database. To open the master key, execute the following statement: OPE
N
> MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
> enable automatic decryption of the database master key by executing the
> following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
.
> This ALTER MASTER KEY statement provisions the server instance with a copy
of
> the database master key that is encrypted with the service master key.
> Is the above correct?
> Thanks,
> Warren
>

Moving an encrypted SQL Server DB to another server.

How can I move and encrypted database to another SQL Server 2005 box?
Can I just do an export of the database?
I read that I need to do this:
When an encrypted database is copied, restored, or attached to a new
instance of SQL Server, a copy of the database master key encrypted by the
service master key is not stored in master on the destination server
instance. On the destination server instance, you must open the master key of
the database. To open the master key, execute the following statement: OPEN
MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
enable automatic decryption of the database master key by executing the
following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
This ALTER MASTER KEY statement provisions the server instance with a copy of
the database master key that is encrypted with the service master key.
Is the above correct?
Thanks,
WarrenIn what way did you encrypt the database?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Warren" <Warren@.discussions.microsoft.com> wrote in message
news:8857450C-395F-4CCA-9E8E-45D11ADC8C2D@.microsoft.com...
> How can I move and encrypted database to another SQL Server 2005 box?
> Can I just do an export of the database?
> I read that I need to do this:
> When an encrypted database is copied, restored, or attached to a new
> instance of SQL Server, a copy of the database master key encrypted by the
> service master key is not stored in master on the destination server
> instance. On the destination server instance, you must open the master key of
> the database. To open the master key, execute the following statement: OPEN
> MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
> enable automatic decryption of the database master key by executing the
> following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
> This ALTER MASTER KEY statement provisions the server instance with a copy of
> the database master key that is encrypted with the service master key.
> Is the above correct?
> Thanks,
> Warren
>

Moving Access Database To Sql Server

Hi folks

I want to move Access database to Sql server but I don't want to use Import/Export Wizard. I want to use DTC Designer.

When I tried to do it I can move only one table between Access and Sql db for every connection.

So, what should I do?

I want to move some tables e.g. ten tables to temp db and then I want to put P.K and Uni. constraints on the main tables then move them and the rest of the tables to the currect destination database.

Did DTC Designer help me on this or should I use Import/Export Wizard.

Thanks guysI would use the Import Wizard or the appropiate Upsizing wizard in Access if applicable for your version of Access.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks for reply

The issue here that Access database contain data not correct. Due to

wrong data, I have to repair them before moving

it. Therefore, I have to design a temporary database and then set the conditions

on the database. The issue here I want to build DTS that move strong entity and

check the data and the conditions. When an error occurs, I want DTS to primate a

message to correct the data manually.

Can you give me any suggestion?

Thank you

|||Thank all for answring

I Moved data by using standard SQL statment

Select , Insert .....

Thnaks

Bye

Moving Access Database To Sql Server

Hi folks

I want to move Access database to Sql server but I don't want to use Import/Export Wizard. I want to use DTC Designer.

When I tried to do it I can move only one table between Access and Sql db for every connection.

So, what should I do?

I want to move some tables e.g. ten tables to temp db and then I want to put P.K and Uni. constraints on the main tables then move them and the rest of the tables to the currect destination database.

Did DTC Designer help me on this or should I use Import/Export Wizard.

Thanks guysI would use the Import Wizard or the appropiate Upsizing wizard in Access if applicable for your version of Access.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks for reply

The issue here that Access database contain data not correct. Due to

wrong data, I have to repair them before moving

it. Therefore, I have to design a temporary database and then set the conditions

on the database. The issue here I want to build DTS that move strong entity and

check the data and the conditions. When an error occurs, I want DTS to primate a

message to correct the data manually.

Can you give me any suggestion?

Thank you

|||Thank all for answring

I Moved data by using standard SQL statment

Select , Insert .....

Thnaks

Bye

MS Reports with out SQL Server

I have a customer using Oracle DB and Oracle Reports (older version), they
need the feature to export reports to excel and like the MS Reporting
Services format. Most of the reports have already been developed in VS2k3
for another customer that uses strictly MS SQL and I have converted these to
VS2k5 and been looking at the ReportViewer winform and webform controls. I
would like to use it in local mode because this customer doesnâ't want a
SQLServer installed anywhere. Ideally I would just like to pass an Oracle DB
connection string to the report viewer and let the SQL in the rdl file do its
work. But, as I understand it, I have to pass the DataTable directly to the
report when using local mode? So is there anyway to open an rdl file and
obtain the SQL? I can then query the DB and pass the resulting data back to
the ReportViewer.LocalReport.DataSource. Any example code would help, I
canâ't imagine all this is required just to run a simple report without a
SSRS? My customer now wants me to consider using crystal reports instead but
I would like to stay on the MS format. Will there be any better options for
this situation in future versions of ReportingServices or the ReportViewer?There are so many examples on the web.
What seems to be a problem?
You can pass any data- no sql server required.
Can't you do something like that?
DataTable reportData = _controller.GetReportData();
rview.LocalReport.DataSources.Clear();
rview.Clear();
rview.Reset();
byte[] data = GetRDL();
MemoryStream ms = new MemoryStream(data);
rview.ProcessingMode = ProcessingMode.Local;
rview.LocalReport.LoadReportDefinition(ms);
ReportDataSource rds = new ReportDataSource("ds", reportData);
rview.LocalReport.DataSources.Add(rds);
rview.RefreshReport();
"Drew" <Drew@.discussions.microsoft.com> wrote in message
news:AE726184-FFE0-4297-974D-C795D02F0E38@.microsoft.com...
>I have a customer using Oracle DB and Oracle Reports (older version), they
> need the feature to export reports to excel and like the MS Reporting
> Services format. Most of the reports have already been developed in VS2k3
> for another customer that uses strictly MS SQL and I have converted these
> to
> VS2k5 and been looking at the ReportViewer winform and webform controls. I
> would like to use it in local mode because this customer doesn't want a
> SQLServer installed anywhere. Ideally I would just like to pass an Oracle
> DB
> connection string to the report viewer and let the SQL in the rdl file do
> its
> work. But, as I understand it, I have to pass the DataTable directly to
> the
> report when using local mode? So is there anyway to open an rdl file and
> obtain the SQL? I can then query the DB and pass the resulting data back
> to
> the ReportViewer.LocalReport.DataSource. Any example code would help, I
> can't imagine all this is required just to run a simple report without a
> SSRS? My customer now wants me to consider using crystal reports instead
> but
> I would like to stay on the MS format. Will there be any better options
> for
> this situation in future versions of ReportingServices or the
> ReportViewer?|||hey buddy i am so sorry that Oracle doesn't have as many features as
SQL Server does.
you should tell them to re-evaluate their database of choice.
-Aaron
Oleg Yevteyev myfistname wrote:
> There are so many examples on the web.
> What seems to be a problem?
> You can pass any data- no sql server required.
> Can't you do something like that?
> DataTable reportData = _controller.GetReportData();
> rview.LocalReport.DataSources.Clear();
> rview.Clear();
> rview.Reset();
> byte[] data = GetRDL();
> MemoryStream ms = new MemoryStream(data);
> rview.ProcessingMode = ProcessingMode.Local;
> rview.LocalReport.LoadReportDefinition(ms);
> ReportDataSource rds = new ReportDataSource("ds", reportData);
> rview.LocalReport.DataSources.Add(rds);
> rview.RefreshReport();
>
> "Drew" <Drew@.discussions.microsoft.com> wrote in message
> news:AE726184-FFE0-4297-974D-C795D02F0E38@.microsoft.com...
> >I have a customer using Oracle DB and Oracle Reports (older version), they
> > need the feature to export reports to excel and like the MS Reporting
> > Services format. Most of the reports have already been developed in VS2k3
> > for another customer that uses strictly MS SQL and I have converted these
> > to
> > VS2k5 and been looking at the ReportViewer winform and webform controls. I
> > would like to use it in local mode because this customer doesn't want a
> > SQLServer installed anywhere. Ideally I would just like to pass an Oracle
> > DB
> > connection string to the report viewer and let the SQL in the rdl file do
> > its
> > work. But, as I understand it, I have to pass the DataTable directly to
> > the
> > report when using local mode? So is there anyway to open an rdl file and
> > obtain the SQL? I can then query the DB and pass the resulting data back
> > to
> > the ReportViewer.LocalReport.DataSource. Any example code would help, I
> > can't imagine all this is required just to run a simple report without a
> > SSRS? My customer now wants me to consider using crystal reports instead
> > but
> > I would like to stay on the MS format. Will there be any better options
> > for
> > this situation in future versions of ReportingServices or the
> > ReportViewer?