Postgres to SQL Express

Is there a utility that will allow migrating Postgres dtatbases to SQL Expre
ss?Thank you for your assistance John.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Patrick
> Postgres is not one of the databases that has a migration assistant
> http://www.microsoft.com/sql/soluti...on/default.mspx so you will
> have to do this manually. The Import/Export wizard may allow you to transf
er
> tables/data across but you may still have to manipulate the data afterward
s
> and change some datatypes, therefore scripting the DDL and
> exporting/importing the data via flat files may be the best option.
> HTH
> John
> "Patrick" wrote:
>|||Hi Patrick
Postgres is not one of the databases that has a migration assistant
http://www.microsoft.com/sql/soluti...on/default.mspx so you will
have to do this manually. The Import/Export wizard may allow you to transfer
tables/data across but you may still have to manipulate the data afterwards
and change some datatypes, therefore scripting the DDL and
exporting/importing the data via flat files may be the best option.
HTH
John
"Patrick" wrote:
[vbcol=seagreen]
> Is there a utility that will allow migrating Postgres dtatbases to SQL Express?[/v
bcol]

Postgres to SQL Express

Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
Thank you for your assistance John.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Patrick
> Postgres is not one of the databases that has a migration assistant
> http://www.microsoft.com/sql/solutions/migration/default.mspx so you will
> have to do this manually. The Import/Export wizard may allow you to transfer
> tables/data across but you may still have to manipulate the data afterwards
> and change some datatypes, therefore scripting the DDL and
> exporting/importing the data via flat files may be the best option.
> HTH
> John
> "Patrick" wrote:
|||Hi Patrick
Postgres is not one of the databases that has a migration assistant
http://www.microsoft.com/sql/solutions/migration/default.mspx so you will
have to do this manually. The Import/Export wizard may allow you to transfer
tables/data across but you may still have to manipulate the data afterwards
and change some datatypes, therefore scripting the DDL and
exporting/importing the data via flat files may be the best option.
HTH
John
"Patrick" wrote:

> Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
sql

Possible to restrict which dbs are shown in Management Studio...

Hi,
I'm migrating a load of databases from a SQL 2000 server to SQL 2005 and was
wondering if anyone knew how to restrict the list of databases that users
see when they connect using the Management Studio to only those that they
have access to? This was done in SQL 2000 by using the following:
http://support.microsoft.com/default.aspx/kb/889696
Any help is appreciated.
Thanks - Joe.In 2005, you have meta-data security built-in. By default, a user can't even see the existence of an
object they don't have permissions to use. Database is the one exception though, but you can handle
that through the VIEW DEFINITION permission.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe Mills" <joemills84@.hotmail.com> wrote in message news:u2y1H$0BHHA.2328@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm migrating a load of databases from a SQL 2000 server to SQL 2005 and was wondering if anyone
> knew how to restrict the list of databases that users see when they connect using the Management
> Studio to only those that they have access to? This was done in SQL 2000 by using the following:
> http://support.microsoft.com/default.aspx/kb/889696
> Any help is appreciated.
> Thanks - Joe.
>

Possible to restrict which dbs are shown in Management Studio...

Hi,
I'm migrating a load of databases from a SQL 2000 server to SQL 2005 and was
wondering if anyone knew how to restrict the list of databases that users
see when they connect using the Management Studio to only those that they
have access to? This was done in SQL 2000 by using the following:
http://support.microsoft.com/default.aspx/kb/889696
Any help is appreciated.
Thanks - Joe.In 2005, you have meta-data security built-in. By default, a user can't even
see the existence of an
object they don't have permissions to use. Database is the one exception tho
ugh, but you can handle
that through the VIEW DEFINITION permission.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe Mills" <joemills84@.hotmail.com> wrote in message news:u2y1H$0BHHA.2328@.TK2MSFTNGP02.phx
.gbl...
> Hi,
> I'm migrating a load of databases from a SQL 2000 server to SQL 2005 and w
as wondering if anyone
> knew how to restrict the list of databases that users see when they connec
t using the Management
> Studio to only those that they have access to? This was done in SQL 2000 b
y using the following:
> http://support.microsoft.com/default.aspx/kb/889696
> Any help is appreciated.
> Thanks - Joe.
>