Jim Lawrence
accessd at shaw.ca
Sat Aug 11 10:56:56 CDT 2012
It is pleasing to note that every major player, Microsoft, Oracle and others have created a series of convertors that make it so easy to import into their particular database. Oracle has a couple of apps that convert from x to Oracle DB and MySQL and it is good to see Microsoft also created the appropriate tools. Thanks Gustav, I will keep your link handy. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Saturday, August 11, 2012 12:10 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Upsize Wizard to SQL Server: Change schema? Hi all OK, I found out that the SQL Server Migration Assistant lets you do this: http://blogs.technet.com/b/dataplatforminsider/archive/2012/01/30/microsoft- sql-server-migration-assistant-5-2-is-now-available.aspx /gustav >>> gustav at cactus.dk 09-08-12 17:45 >>> Hi all I'm using the upsize wizard in A2010 to SQL Server. When I use it with my SQL Server 2008 R2 Express, it creates tables using the schema dbo: dbo.SomeTable However, if I it run against an existing database on a non-local SQL Server 2008 R2, where I've used other credentials to create the database, the database file (of course) does not have me as user as the owner. This seems to force the created tables to use my credentials as the schema, like MyDomain\Gustav. Thus, tables are named: MyDomain\Gustav.SomeTable This is fine if the tables were "mine" but they are not How can I prevent this? /gustav -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com